Conditional Formatting for cells containing duplicate values not working
Hi, I noticed today that the conditional formatting that is supposed to highlight cells containing duplicate values does not work anymore. It now highlights all cells even if there are no duplicates. This behavior changed today as far as I can tell. See
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
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,
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);
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?
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
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
Not show data in sheet
Hi everyone, I am new user on this site and I haven't properly knowledge about this site. So, i have an issue, when i am open file in sheet there are no date shown, even i have been checked whole setting but can't access. All, files are very important
How can we add formulas in excel sheet
hi everyone, I want to calculate some high amount date about my website, which can't be easy to calculate on caculater. So, i want to add a formula for easily calculation. please let me know about the formulas, how to it properly. Thanks
External Publishing
I am trying to publish a sheet externally and have selected the "Allow Download" but when viewing there is no way to download. Also the sheets are in a different order. Instead of Sheet1, Sheet2 the published shows Sheet2, Sheet1 order.
Maximum limit of rows and columns exceeded
I have entered a date in column and wish to extend it day by day to all columns till the end of sheet. But sheet shows that I have exceeded the number of columns. Zoho Sheet has many bugs and looks half baked product.
How to Search Items in a Picklist on Sheets
When using the search feature in sheets, if I'm looking for an item that is in a picklist it cannot find it unless it's the present item in the cell. Is there a way to search items, regardless of their position in a picklist?
integrate nomic or coinmarketcap API on Zoho sheet
how could i integrate an external API from coinmarketcap or Nomics in my Zoho sheet
Next Page