Is there any option to directly download my spreadsheet in csv or json?
Is there any option to directly download my spreadsheet in csv or json? If yes then, how many requests per second Thank you
Unlocking a shared spreadsheet
I was just testing out the shared spreadsheet feature (one of the things we are most excited about!), and am uncertain how to unlock a spreadsheet after I'm done editing it. For instance: * my husband & I are both logged in to Zoho Sheet. * I have given him read/write access to one of my sheets, which he is currently editing. * He saves the sheet, and then selects another sheet to edit. * At this point, I expect to be able to select our shared sheet, and edit it myself. Instead, I receive a message
Deleting shared spreadsheets
Hello I was just wondering what happens to a spreadsheet that I've shared when I delete it. Does it delete it from everyone or just me?
Zoho Sheets seem to be down
Zoho sheets keeps saying there is an error or loading a white screen.
Question about the functionality of zoho sheet
Can I add footer to sheet?
Use of Unique function in Data Validation for Zoho Sheets
Hi There, Can I use the Unique function to a data validation so that the dropdown only populates the attributes of a column. Or do that with a cell reference. In Microsoft excel, this can be done by adding a # so that the cell reference picks up all the
Won't Print - Server Error
In typical Zoho fashion, something doesn't work and an ultra-vague, totally unhelpful error appears. This time, I'm trying to print my spreadsheet. Okay, I did try again. Still doesn't work. Now what? I'm extremely frustrated with this program. I made
link to tab in Zoho Spreadsheet
Is there an easy way to link directly to a tab in a spreadsheet from an external site? For example, I want to link to Tab2, but the zoho sheet only provides a single URL. How do I direct traffic to one particular tab in a spreadsheet, and have another link that directs to another tab? Thanks
Recommended Broswer for Zoho Docs
All my Zoho apps work great except for Docs. It simply runs slow buggy compared to all other Zoho apps. This is regardless of using Windows 7 or Ubuntu 12.04. I have tried Chrome, Firefox, IE 9 on Windows and Opera. is there a recommended browser OS combination for Docs? Also, I have not been able to get offline mode to work, all I get is a blank page that has the loading message.
Cut -> Paste values and formats in single Spreadsheet
Hello, I am stuck with CUT-PASTE with the following behaviour of spreadsheet: 'Sheet-1'.A:A has [conditional formatting] and [data validation] and 'Sheet-2'.A:A has the same configured rules for [conditional formatting] and [data validation]. When I cut
Rotating text
It would be very useful to be able to use text vertically and not just horizontally.
Remove Total from Pivot Table
Can I remove the Total and Grand Total of my Pivot table?
Sheets oauth scopes
Is there a list of OAuth scopes I should use for API access to Zoho sheets?
Zoho Sheet Embed options
I would like to be able to embed an active sheet into a web page, i.e visitors to the page can enter data to see changed results but cannot edit the sheet in any other way. Regards PETER J WILLS Business Consultant & Adviser ABN 53 964 553 113 www.bcaservices.com.au pjpw2320
How to combine multiple sheets in one IMPORTRANGE?
in Google Sheets and Excel, there is option for this and it is helpful in extracting data. Does Zoho Sheet also support multiple importrange? If so, please help me.
Split date and time with space as delimiter
I am trying to separate the date and time in a cell into 2 separate columns. The value in the cell is Mar-25-2021 13:46:49. I want the next column to show Mar-25-2021 and the 2nd column to show 13:46:49. The split function that I normally use in Google
Using a Macro as a Function Called From Cell to Populate a Cell Value
I'm trying to populate individual cells with function calls to a macro similar to how one would use a regular function to populate a cell. My function is: Public Function getHours(item As String,high As Number) As Double Sheets("Work Items").Select
Duplicate a Spreadsheet
There are 2 ways to duplicate a spreadsheet in Zoho Sheet . 1. Using 'Duplicate' Option : Click the 'Show Sidebar' arrow or Press Ctrl+O to open the sidebar. Click the Actions icon of the corresponding spreadsheet name and select the 'Duplicate' option from the dropdown menu. A new copy of the spreadsheet will be created with a name in the pattern 'Copy of <original spreadsheet name>'.For example, when you duplicate a spreadsheet named '401K Planner', a new copy of the spreadsheet will be created
Zoho Spreadsheet New Line Shortcut?
When I use Google Sheets I can press: CTRL SHIFT and + ..to create a new line. When I try to do the same in Zoho, I get a message: "Column limit exceeded" Is there a shortcut to create a new line?
Spreadsheet VBA not working with same VBA code used in Excel
I uploaded my excel file to zoho and wanted to run the same file here. The problem is that it gave me errors regarding the vba file. The error was with "inputbox" function used in the VBA code. Now either zoho vba uses a different function for "inputbox" or i dont understand whats wrong. The reason for the vba code was to get data from a public xml api to that spreadsheet. So please help me out.
Is it possible to publish a spreadsheet to a website?
Hi, I'm new to Zoho and investigating if it will allow me to do what I'm intending. I'm creating a solar system generation calculator in spreadsheets that I want to publish to a website. Is it possible to do this? The sharing feature seems to only let you share with other Soho members.
Open files Very slow
Hi Compare to gDrive, sheet opening seems to be slower I wait a long time and made a little screen to show you (I started and stopped before the end
If (Cell) Than (Text)
Hi how do I use this formula in Zoho sheet? =IF(B4="true";"part1";0). I'ts not giving me the result. Please Help
Double Quote in the Concatenate function
Hi I am trying to put double quote in the concatenate function (something like -> I prefer something "sour" when it comes to deserts. I tried putting two double quotes, didn't work. I also tried putting \" also didn't work (somehow, it would add one more bracket at the end when I put \" Can someone tell me how to resolve this, thx in advance.
How do you enter numbers as text?
I've imported an existing spreadsheet with cells that have numbers as text (they're id's and should NOT be treated or formatted as numbers.) Zoho sheets handled this correctly (yay!) But I can't figure out how to enter new ids. In every other spreadsheet
VBA Find and Replace - "Replace" button changes next "Find" result, not the text currently highlighted
I just tried to use the Find and Replace functions in the VBA Editor to change some variable names I had used in my macro code. When I enter text in the find box and search for it using "Find", the text is found correctly in the code and highlighted.
Zoho Sheet redirected to "Zoho WorkDrive - Create Team" dialog, now I'm signed up for something I never agreed to
A short while ago I tried to open one of my spreadsheets via the web on a Windows PC, and I couldn't. No matter which of my bookmarks I clicked, the spreadsheet wouldn't load and instead a prompt appeared asking me to choose a team name. I don't mind
VBA Script will not stop running
I have a script to clear checkboxes in a range and it works perfectly, except it will not stop. After it runs I want to be able to use the checkboxes again for calculations, then run the macro to clear them, then reuse the boxes as needed. As it is written
Sheet doesn't display correctly after macro runs
Hi there, I'm using the following code as part of a macro in one of my sheets, to record information from one worksheet into another: Sub LogTaskComplete(ByVal taskName As String) Dim currentSheet As String currentSheet = ActiveSheet.Name
Error message trying to open spreadsheets
Hi, I am receiving the attached message with I try to open all but one of my spreadsheets.
cut and insert
in most spreadsheet docs (Excel) when you cut the data from one area and try to put it somewhere in the same sheet the rest of the sheet is automatically moved down so that it fits in without overwriting any other information. however in Zoho any cutting moves the intended rows but overwrites other rows unless you specifically create a space of the correct size for it. this would save a lot of time if the sheet acted more like Excel in this regard. thanks.
Sheets - Data Validation not working properly
Hi there, I have a document with approx. varias sheets in it. The information input into 3 of these sheets is sent to its respective Pivot Table. Another Sheet has 3 columns set up with Data Validation pulling the information from the pivot tables.
Sheets - Return to last cell
I can see in the URL for sheets, that the end of the URL points to the sheet and range in the sheet. Is there a way to have the URL return you to the last cell you were working on after exiting and reopening the sheet?
Drop down menu in Zoho Sheets
Hi, I was wondering if (like in Microsoft Office Excel) you can create drop down menus' in Zoho sheets. If so how do I do it? Cheers
exporting as pdf not working fine
I did try to export sheet as pdf and not working properly. please fix this. vikyboss
More colors
Hello, Help me understand, while working with sheets, I go to "more Colors" select a color I like and use it in my spreadsheet. However, once I close out that sheet then later reopen it, the color I selected from more colors is not there. Why and what
Announcing IMPORTRANGE and cross-spreadsheet linking in Zoho Sheet
We are pleased to announce the much-requested IMPORTRANGE function in Zoho Sheet. With this function, you can now link or refer to cell ranges across spreadsheets in an instant. Refer across spreadsheets You can use IMPORTRANGE just like any other predefined function in Zoho Sheet. Start with an equal sign, select the function, and fill in the parameters. For this function, the source spreadsheet link and the desired cell range to import are given as input. Once you allow access to the source
Zoho sheets not loading
When I try to open certain sheets from the list of zoho sheets I have few that will work perfectly whilw others will end up in a blank white screen.
New look, improved usability, and more: the exclusive Zoho Sheet app for iOS and iPadOS
We are constantly working on improving the Sheet mobile app and its usability in terms of speed, design, features, and overall performance. With these aspects in mind, we are excited to announce an exclusive Zoho Sheet app for iOS and iPadOS that will
Tab Colors and New Currency Symbol of Indian Rupee
Zoho Sheet has recently added support for the following 2 new features: Tab Colors: Since last month, you can set a color to your worksheet tabs. Use colors to quickly identify/highlight specific worksheets or to group similar worksheets together. This option is available on the right click context menu of the worksheet tab. Add color to your worksheets! Indian Rupee Currency - New Symbol: The new Indian Rupee Symbol, ₹, is now supported in Zoho Sheet. This replaces the old "Rs." currency symbol
Next Page