How to change sheet alphabet color ?
Help
Some Company Users Display As External User?
Hello, why do some our staff emails show up as external users even though they have the same URL? Thank you
Characters are jumbled no matter how slowly I type them
I'm not sure if this is a problem for others but I've found the new interface much slower to load and so on. Now, today, when I type in cells, no matter how slowly I type I am getting the words/figures scrambled. So if I was typing cat, I could end up with act or tca or cat. I am almost having to reposition the cursor for each individual letter or number I type. I'm still using the exact same browser, computer connection etc but this is very frustrating and makes Sheet too slow to be useful.
Using Flow to import data from Gsheet
Hello with out going into detail as to why I do this I just need help solving this. I have created a script in gsheet to send sheet data to a webhook in Zoho Flow. From there I want send this data to Zoho Sheet. I currently have the following code below
Zoho Sheet and Zoho Flow integration
Hello, I have integrated a spreadsheet with two worksheets with Zoho Flow. The trigger 'Row created or updated' works well if I manually update the worksheet. However, I have enabled a macro through a button in one of the worksheet to modify the worksheet
Zoho Sheets Filter Issues
I appear to be having ongoing issues with my filtering in zoho sheets. Occassionally random cells will not filter in accordance with the rest of the sheet. Usually I filter by time, and then date - this allows the full sheet to order by correct date &
Format change when Filtering
I have a large list of medical claims in a Zoho Sheet. Column A contains a picklist to update the status of each claim. Normally this works wonderfully, but lately, when I filter for a particular patient (or service, insurance company, etc), then work
Disconnect other users from file
We have a shared file that multiple people update occasionally. There are some users who select cells and then do nothing for days at a time. The "active" users seem to be slowing down my access to the sheet. Is there a way to disconnect anyone that is
Sum through multiple sheets
Don't believe this command works in Sheets sum(sheet1:sheet6!A4) Would be nice to add. Every time I click on sheet3 it moves to that sheet instead of treating it as a formula input
Issue with TEXT Function and Displaying Day of the Week (Zoho Sheets)
Hello, I'm using the formula =TEXT(DAY(A1);"DDDD") in Zoho Sheets to display the full day of the week for a date in cell A1. However, when I enter a date like 2/7/2024 (MM/DD/YYYY), the formula doesn't return the correct day (Wednesday in this case).
Make cells bigger
Hi I am new to ZOHO. How do I make the cells bigger in ZOHO sheet or make the cell grow when I type text into it?
Excel sheet embed in website
Sir, How to embed an interactive excel sheet into my website without displaying the other sheets like sheet 2, sheet 3 etc. I am ok with the zoho logo on the top right.
Download Failed from sheets
If I create a spreadsheet, then select the area, I go to download as PDF and it says Download Failed. This has worked for years, but suddenly today it hasn't. I have tried on different browsers, linux and Windows with same results.
Bitcoin
How can I get the current price of Bitcoin using a function similiar to the "stock" function?
Data Validation Rules dissapear for no reason
I set up all my data validation rules in zoho spreadsheet, and now this is the 3rd time that they have dissappeared!! Every Single data rule i set up! Why does this happen? Is this a bug? Im getting really tired of having to redo it every time
VBA to automatically update the current date.
Hello, I'm looking to have a VBA to keep the date of the day automatically updated without having to refresh or openmy Zoho sheet. I've tried this but it doen't work, can you please help? Here is what I tried: Sub date_update() Range("H1") = Date Application.Calculate
Excel Answer to Zoho it seems
I can’t edit zoho spreadsheets in chrome on my mobile, period. They were created on my laptop with no collaborators. I’ve installed ZS app on my mobile, and I can edit but all of the DVs are corrupted - intact but in the wrong places. I am very frustrated
drop down dv not working with table
I've decided to swap out my working DV sourcing a cell range, to a table. I table create the data and redo the DV. I select the source data and it automatically loads "Table 11" into the DV box, but when completed there is not drop down arrow at all in
Can we revert templates to previous versions in the version history?
In the help help on version history it says "click Revert in the toolbar." That 'Revert' button is there for spreadsheets, but does not appear for me in templates. Is it missing? Is there a way to revert templates to previous versions?
Is there a way to send a Zoho Sheet signed with Zoho Sign?
I am using Zoho Sheets to create our employee files. We like using Sheets as we can use formulas and add as many lines as needed as the years' updates on salaries and job titles are updated. Is there a way to have the document sent for signature to the
Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
Anyone Can help me converting Excel VBA to Zoho Macro?
The Macro in general is pretty simple, It just opens a Workbook and copys some of data from that Workbook to the one that was initially open. But when I try to use it on Zoho I get this error "Unknown function: GetOpenFilename". If there is any other
Zoho Sheets working offline
Hi, I am looking for the ability to work offline in Zoho Sheets, but currently I cannot find the process to complete this. Does someone have any ideas or steps I might have missed? Also does Zoho Sheets have the "Format as Tables" function as is currently in MS Excel 2016?? Many thanks.
With what formula can I find the last month of the year?
Hello. You did what Google did not do. Firstly, thank you. I turned the Google sheet into a Zoho sheet. With which formula can I find the last month of the year and the last month of the previous year? Now an incorrect result is coming. For example, for
Beveled Edges on Zoho sheet charts
Hello, I have a question about charts in Zoho sheet. Could we make beveled edges on the charts? Would really appreciate any response. Best regards, Harrold
missing side bars
Hi there, a member of my team has an issue with the scroll bars going missing on her sheet. is there any reason for this and any solution to the problem? attached is a screen shot of the problem.
How to reference cells from another workbook
Hi, I just like to ask for help on how to reference a cell from another workbook. Thank you. Harrold
Announcing Zoho Sheet's monthly webinar series
Hello there, At Zoho Sheet, we always strive to help you maximize your product experience. Hosting webinars has been one of the key ways for us to communicate product updates, share best practices, and engage the user community. To help you conveniently
Convert text to number
From Zoho CRM, there is a button "Zoho Sheet View" that converts the current view into a spreadsheet. One of my columns in CRM is Amount (a dollar value) but it converts those values to text in the spreadsheet. Is there a simple way to convert text to a number rather than going to each cell and deleting the preceding single quote? the same question applies to the date column. All the dates are now preceded with a single quote - is there a simple way to convert these from text to dates?
Anyway to disable autofill?
When in putting In strings of text in multiple cells. The auto complete can cause a lot of problems in make it almost impossible to enter what you want. It almost makes it unusable.Is the beginning of a long string of text is the same it will try to
Update date & time when a cell is edited
Hi All, I am desiring to have a cell update with the current date and time when another cell is edited. Any ideas? Thank you
Collaborative editing of spreadsheets by multiple users simultaneously - Is it really possible?
I work in a SharePoint 2010/SharePoint Server 2010 environment and we use MS Office 2007(Excel 2007) . I have been trying to create a MS Office document which will allow multiple users to work on a spreadsheet simultaneously. For that I have: 1) Created a excel workbook and published as a workspace as suggested by Andrea Kalli in her link: http://www.wonderhowto.com/how-to-collaborate-files-between-sharepoint-and-office-2007-182172/ 2) Set up and saved the Excel Workbook as "Shared" and made it available
How do I share a single sheet from ZOHO spreadsheet?
I am sure I saw this option 15 days ago. I just stumbled on it and can't find it any more. I would like to share one sheet of a single document to each collaborator. Was it not possible? Thanks in advance!
Red dashed line around cell
I have a red dashed line appearing around a cell. It does not go away when I clear formatting and I'm not sure how to get rid of it. The formula in the cell is quite simple and the cell is displaying the correct result. The outline also persists if I
Connect a form with a Spreadsheet
I have a spreadsheet that performs once-off calculations on inputted data. I made the input fields editable and locked the other fields, and that works on a desktop browser (Firefox). However those fields are not editable on a mobile browser (Firefox
importXML function and related use case
Hi, I would like to know is the spreadsheet roadmap plans to implement the importXML function? My use case is as following: - I need to get date from a web page and then to compil them - I would like to publish the result in a blog in a form of the dynamic table. The table value must be updated as per the web value. - Because many people ask the way to do that with an online spredsheet, I prefer zoho then Google spredsheet, because when you share a range, the user can style edit it whithout modifying
IMPORTRANGE with table references?
Can IMPORTRANGE be used to get a table instead of a range? More specifically, can I use column references to only get the columns I want instead of the whole table? I want the imported data to grow as the table grows. I've tried this: Where my table name
How can I stop a NOW() from update every time I open the sheet?
Hello, I'm trying to use the current function =IF(B1<>"", NOW()). Is it possible to update the NOW() function only when the B1 cell is modified and not when the sheet is opened? Best regards
List Range In Zoho Sheets Data Validation
Hello, I have 2 worksheets "Sheet 1" & "Sheet 2". I want to set data validation in Sheet 1 but using a named range for the drop-down list. I have set a dynamic named range CSID "OFFSET(Sheet2.$A:$A;0;0;19999;0)". I tried typing in CSID in the list or cell range but it didnt work like Excel. Please help, thanks.
copy format ?
Is there a way to copy the format from one cell, or group of cells to another cell or group of cells.(like the format paint brush function?) Thanks,
Next Page