Spreadsheet
How can i limit the number of rows and columns in zoho spreadsheets? Thank you Bruno
Zoho Sheet - Server Error
While trying to copy a Spreadsheet, I am unable to do so. Following message pops up - Sorry! You cannot copy or download this spreadsheet since it contains hidden data within locked ranges- how to solve it?
Can I share my Zoho spreadsheet and database?
I do the job of data entry any I perform my job on Zoho. my question is can I share my Zoho spreadsheet and database to other websites and lenovo laptop rental. If yes, how can I do it? Looking forward to your answers.
How to set chart range
I have a spreadsheet in which a new row of data is put in for a date. General layout is 1st column = Date and each column in that row is the value associated for that date. I chart this data using a lint chart, and always want the last 25 days o show
Is there any way for recovering of deleted sheets?
Hi, I hope you all are doing good. I lost my important data. All data on the sheet is about the general details of the putters. Unfortunately, it was deleted by me. I am looking for a recovery option. If there is any possibility or any way then kindly
Zoho Sheets and Docs Link Integration
When I use google sheets, I can copy data in the spreadsheet and paste it into a google doc. A prompt will then ask if I would like to link the data of the worksheet. If I select yes, then the data changed in the google sheet will be changed in the google doc, simply by clicking an update icon. Is this feature possible between Zoho Sheets and writer? This is a huge time saver in writing reports where only certain data needs to be changed between clients. Thank you.
Link sheets to zoho analytics table
Possible to link/update zoho sheets via tables in zoho analytics? I have been unable to find documentation related to this question.
Conditional sum calculation
Hi everyone, I have a bit of a brain teaser in a Zoho spreadsheet. I'm attempting to do a sum on a cell if another cell is not empty. It's a very simple calculation, but I'm struggling with getting the condition to work. If cell B3 is not blank, I want to deduct the amount in B3 from a fixed amount (22000). Essentially it's a running total showing how much is left to accrue. I want to use that formula in C3 and then repeat it down the rows. I've tried all of the following in cell C3: IF(B3!null;=SUM(22000-B3);)
Form Date Time not working in Sheets (Zoho Form with Zoho Sheets Integration)
hi, I've been using the 'Added Time' from a Form to Sheets since April. It worked perfectly, but for some reason since 20 December Sheets will no longer recognise the 'Added Time' as a Date Time cell. The cell format is correct, and the Form & Sheets date/time/region are set as UK GMT. Please advise how to correct this issue and the reason it suddenly started? Please see in column A the Added Time is OK for the first row, the date/time is in the right of the column and in column B I am able to do
Cell format to allow spilling over to right
I Excel and prior version of Zoho Spreadsheet... the data entered into a cell would display in the current cell and spill over into the cells to the right if they were not filled. The new version of Zoho truncates or maintains the display to the current cell only. Many of our prior spreadsheets used the spillover area in headers, but would now require each of these cell to be Merged for display purposes. Is there a way to allow the cell to display to the right is not occupied by data, as in the
Spreadsheets
Upon opening my account with Zoho I was asked if I wanted to try the newest version of spreadsheets (docs) but now I'm thinking I might want to go back to the older version (the I had before I upgraded to thee new) can I do that ? Go back to the previous version ? Thanks & Regards, Bruce
Shared With Me
Hi, I received an email that someone has shared a spreadsheet with me. This is the same email account that I use for my normal Zoho login. When I login using my normal credentials through browser/ios/android I do not see the shared spreadsheet. Presumably it should be in 'Shared With Me' in the apps? Why is it not showing? I think on their own account creation they selected an option to do with EU, I'm in the EU but using zoho.com Certainly the emailed link uses zoho.eu and proposes a signup (but
Problems with date calculations in sheet
Hi. I wonder if someone can help me. I'm a volunteer book review editor. I use Zoho Sheet to keep track of books out. I have a column where I keep the date a reviewer receives a book, and another column that tracks when the review is received. I check that the date reviewer receives the book not empty, and that the date the review is received is empty. The reviewer has the book, but has not submitted a review. In another column, I'm wanting to compute the date the review is due -- 30 days
Conditional formatting cells by date (monthly)
Hi all, I would like to conditionally style cells in the A column (all dates), where the date is the 25th of any month/year. How can I achieve this? Thanks!