Organizational Charts
Hi, I usually create org charts in excel using shapes. Since Sheets does not have Shapes function, does any one have any suggestions on how to create an org chart in ZoHo family of apps? thanks David
Value of last populated cell in a column
Hello: I want a formula to return the value of the last populated cell in a column. In Excel and Google Sheets, the following formula works. =LOOKUP(9.99E+307,F:F) However, in Zoho, this formula returns the largest value in column F, not the last value.
Why is "Generating Preview" freezing/ go blank when I try to Print?
In Zoho Sheets, when I go to print it freezes when it's trying to generate the preview, and I cannot print or save as PDF. I've tried refreshing the page, restarting my computer, logging out/in, using a different browser... still stuck with a blank screen
How to add a hyperlink to a cell or image? (Not text)
Hi, Is it possible to add a hyperlink to an cell or image? And as a follow up question, upon pivot table creation, will the image/cell with link be taken into the pivot table? Thank you, Tiemen
Is it possible to collaborate online on ZohoSheet not sharing all information ?
I want to collaborate on the zoho sheet with multiple people who will input their own data but I don't want to show them the consolidated sheet and also other peers' data. I understood that (at least at the moment) I can't share a single sheet or individual sheets with different people in zoho sheet. Then I want to give to my collaborators an access to the individual work books with editing permissions and then fetch/synchronize these data into my main workbook automatically. So, could you clarify
Import your Google Docs Spreadsheets into Zoho Sheet
You can now import your Google spreadsheet into Zoho Sheet. This will be useful if you want to switch to Zoho Sheet or if you want to simply try out Zoho Sheet. If you don't have an account with Zoho, you can still try this by signing in with your Google account. Here is a video on how to do this. Note: Existing charts won't appear in spreadsheets you import from Google Docs as the Export functionality of Google Docs doesn't give out the charts. Check out the announcement in our blog: https://blogs.zoho.com/general/import-google-docs-into-zoho-productivity-suite
How do I use the filter in the Zoho Sheets Mobile App
When pressing on the filter icon in a Zoho sheet on a mobile app nothing happens. How do I activate the filter from on a sheet in the zoho mobile app?
Use Relative Reference feature inside the zoho sheet
I have 2 pages inside one of my zoho sheet spreadsheets. One of them is the factor of the customer and the other one is the database of all of the customers' factors. I need to have a record by macro that whenever I run it, the information inside the
Refine by Zia: a smart way to improve data quality
Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,
Countif for ANY text String
Pulling over formula from Google Sheet of =COUNTIF(B2:B11;"*") to tabulate cells in the set with ANY TEXT. What is the converted formula in ZOHO to achieve this?
No Side Scrolling In Sheet
Hey there, I've been having an issue that's recently come up where my scroll bar for horizontal scrolling is locked in position. The bar will move but the page does not and upon release, the bar immediately goes back to the far left of the scrolling range.
Zoho Sheets Not Linking Anymore to other Zoho Sheets with Formula =IMPORTRANGE
I have multiple Sheets using a formula =IMPORTRANGE which were working prior to the recent crash. Every time I either get a Not Link error (so I re-link the sheets) and give me an error #EVAL! I have attempted to create two new sheets and attempted to
How can i add up times with format "mm:ss,000"?
Hi! I want to be able to add up times with minutes, seconds and milliseconds. That is easy to get in Excel by formatting cells as mm:ss,000, but Zoho Sheet doesn't recognize it where import the .xsl file. I was looking all different options but I did not find how to format cells like this way. For example: 1:29,002 1:32,010 -------------- 3:01,012 Any workaround? Thank you very much.
Webinar: Learn how to instantly clean your spreadsheet data
Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration. In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid of
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.
Next Page