Offline Work
I see how to work offline with Zoho writer how do I do the same with Zoho Sheet? mark18
Sheet Default Font
Is is possible to set the default font and font size in Zoho Sheet ?
Share a particular sheet with someone with daily changes update
I want to share particular sheet with someone, so that after a change is made, it will be auto-updated in main sheet. Yes I know I can publish it and give the link to update them, but I want that after they do changes in the shared sheet, it should also
Regarding Automation
I need to understand, how to automate deadlines in zoho sheets so that the tab color changes as soon as deadline is passed into red, while before time makes it green and on the way keeps it yellow. Please help in this regards.
Do we have auto mailer like outlook in Zoho also by using vba ? or any other option.
I want to automate mis by using auto mail from excel, do we have this facility in zoho like outlook?
Inconsistent Autocomplete
Throughout my Zoho Sheet document, it seems that most of the cells will not autocomplete. If I enter information in a cell and want to add that same information to information in a cell below it, most times I will have to type the entire string of words
Need Deluge access rows and columns in a pivot table
Can you provide some sample code to access the rows and columns of a pivot table? I can rely on using a named range but where does one name / change name of the pivot table? Just need a little sample code to get me going in the correct direction. Thank
Docs Sheets very slow?
Are Sheets always this slow? We have been testing ZOHO Sheets as a replacement to Google Docs, but we keep hitting patches of the day where it grinds to a halt. It is either really slow or it will load only a few lines from a sheet and just hang and we have to log out and back in again to get it working,.... We are experiencing it on several computers on various OS and Browsers. We are in Spain, but on 100Mbps Fibre so I don't think it is an issue on our end. Any advice or solutions? Thanks Alex
Convert Hijri to Georgian Dates in Sheets
Hi, Is there a way to convert the Hijri (Islamic) dates into Georgian dates (formula, VBA ..or any)? Thanks
doesn't have shared sheet
Due to System error shared sheet doesn't show me.
Retrieving user ID through VBA
Hi, is there a way to retrieve User ID who did entry on a specific cell and put it on other columns using VBA? eg. if cell A1 changed, User ID to be added in cell B1 Thanks,
Tip #9: 5 common spreadsheet errors and how to solve them
Functions can help you automate your calculations and pull important insights from your data set. However, if something goes wrong with these functions, errors occur and make your spreadsheet less reliable. These errors usually have a cascading effect,
Retrieve Username in VBA
In Excel I can utilize the username of the individual logged into the computer with Environ("Username"), is there any similar function in Zoho sheets so I can retrieve the name of the individual logged into Zoho? Thanks Jon
Use of Combobox in worksheet.
Combo box is very useful for set cell value from some choice. So, please Give some solution.. and thanks for your replay.
Export Pipe Delimited CSV out of Zoho Sheets
Hello Everyone, I have a spreadsheet that I need to export to a txt or csv file. I know how to export it as .csv file that has a delimiter of a comma. However, my data has commas in it. Because of this, we've set up our import code for our program to
Cant share the Sheets to anyone
Hello everyone I'm the employ of Shashwat Stainless Inc, I cannot share the sheets to anyone.so please suggest me a suggestion, It shows you can't share this file
Import from Microsoft Access Query
Is it possible to connect a Zoho Sheet to an MS Access database query and import the query data to the sheet?
group and ungroup
How do I group and ungroup columns and rows jakob_kishon
Deprecation of Zoho Sheet's view.do API
Hello all, The Zoho Sheet view.do API (https://sheet.zoho.com/sheet/view.do) accepting URL and file stream parameters (provided in https://sheet.zoho.com/sheet/excelviewer) has been deprecated, and will no longer be available to use from July 31, 2019. Any code written using this API will stop working after this date. The Office Suite APIs are available as an alternative via Office Integrator. Learn more here. If you have any questions about Office Integrator, add them as comments below or drop
zoho Sheets - Cannot center align a cell
For some reason on this worksheet I cannot center align the cells. I might be doing something wrong, but I have used a lot of spreadsheets and not encountered this issue. 🤷♂️ This is on an iMac in Chrome. screen capture attached
Zoho Sheets Slow Processing
We are trying to use zoho Sheets in our day-to-day, but... We encounter times when Sheets is updating so slowly that it nearly becomes unusable. The dreaded working notification. Very frustrating. Other online spreadsheet applications have set the usability
Conditional Formatting Enhancements
We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns falls
One cell, multiple formats, unlimited possibilities.
Spreadsheet formats are more than an aesthetic choice. Proper formatting helps audiences understand your spreadsheet better. Zoho Sheet now allows you to format different parts of your content in cells however you want. What can you do with the new formatting
Can vlookup work between workbooks?
Can vlookup work between workbooks?
=IMAGE("URL") Function isn't working today
Dear Zoho Team, I've been using =IMAGE("URL") function on the regular basis, but today it just stopped working. Please check and fix the issue.
vlookup in another page?
Dear officer, Can I use vlookup function to search value in another page? e.g.=VLOOKUP(F2;(sheet 2)A3:C9999";3;FALSE) Regards, Jansen
Copy formula
Can I copy a formula to other cells and will the formula adapt to the newcell? Wim
more than 24 hours
With Microsoft Excel, it is possible times to count more than 24 hours example : 13:00 + 14:00 = 27:00 cellularity with microsoft excel = [hh]: mm Is this also possible with zoho sheet ? zoho sheet returns 3:00 instead of 27:00 :-( sorry, I know bad english
A lot of spam from @notifications.zohosheet.eu address
In last week Inbox.lv email service has problem with spam from ZOHO side. More that 100K letters daily. I wrote about problem to your system emails, but unfurtunaly w/o answer. As quick fix, we tried to block your IP addresses, but we hope to the helping
How to call existing function within a custom function
Hello, I'm using the script below to create a custom function but it gives the error "not able to find PV function." How do I call the PV function? float PVD(float rate,float n,float d,float pmt,float fv,int type) { PVD = PV(rate,n+d,pmt,fv,type)-PV(rate,d,pmt,fv,type);
Tip #8: Using RAND and RANDBETWEEN functions to generate random data sets
Have you ever spent hours working on a sample data record for a demonstration? We're here to show you how to do it in less time. If you want to generate a sample data set for a demonstration, or just to learn how a pivot table works, using the RAND and
use of create list and manage list
How to use create list and manage list
Zoho Sheet Edit Cell Format
It seems as though if you want to BOLD something in a cell, it applies to the ALL the text within the cell. How can you just apply to SOME of the text within the cell?
How can I set Zoho Sheets to Auto-Complete when entering cell data that was used for other cells in the same column?
How can I set Zoho Sheets to Auto-Complete when entering cell data that was used for other cells in the same column?
Number formatting
How do I format numbers in Indian Style like Lakhs and crores
I cant edit my own file
Hi There, I can access my file but i cant modify. Appears the follow message "Unable to connect to messaging server"
Spreadsheet language setting is broken, causing data loss
Dear Zoho, Some time within the last week, your code relating to the language settings for spreadsheets changed. Since that time, the date formats for all date and time cells in my spreadsheets have been incorrect. This is interfering with macros that
Zoho Sheet won't open in iOS
Every time I try to open a Zoho sheet from either the Workdrive or Zoho Sheets app, it says that "There's a problem in opening the spreadsheet. Please reopen the file." Any ideas?
Referencing cells from another sheet not working anyhmore. Strange behavior.
I have just noticed that referencing a Cell from another sheet in Zoho docs no longer works. It shows "#NAME!" error. It was very easy to test: 1. open a new Zoho sheet 2. create a second sheet: "Sheet2" 3. In sheet2 in on cell type the value: ='Sheet1'.A1
Tip #3: Save your time by replicating formats
Formatting helps to create more visually appealing spreadsheets while keeping data organized. Selectively applying formatting options to your work, such as applying fonts, currency formats, or colors, can be time-consuming and repetitive. Replicating formatting guidelines for your work can help remove the burden of applying these menial tasks, which improve overall productivity in your workflow. Let's say you are collaborating on a spreadsheet with your team and you have to create a combined report.
Next Page