conditional formatting not working when applied to range of cells
I am having a problem applying a conditional formatting to a range of cells. I have 3 conditional formats. They are all Classic - Formula. The formula is one of: b3<today() b3=today() b3>today() When I apply these conditional formats to a single cell
sharing with a group
I have created a group and added members to it, but I do not see where/how I can share a sheet with that group. I only get the option to share using email addresses and that has limited me to 20 users. I need to share with more than 20 users, so I was
Migrate particular row to another workbook
I need help with migrating a particular row, when the particular task is assigned to certain person within department, the task is auto added to the department HOD Ex. Task A is assigned to X, and I want the whole row to be reflected in X workbook.
Zoho Sheet - Printing - Page Breaks and Printing Customization
I think the title is descriptive enough in that I cannot find help documentation on a simple task of adding in page brakes for separating pages on print. Thanks
Kindly need a macro to lock cell after a data entry
Hi, I am not very used to Zoho VBA and actually I am not good enough to write a macro from scratch. I'm wondering if anyone would be so VERY kind as to show me the code needed for this problem : I'm trying to lock the cells automatically when data is entered. The code for Excel VBA should be like this : ActiveSheet.Unprotect ' Password:="secret" For Each cel In Target If cel.Value <> "" Then cel.Locked = True End If Next cel ActiveSheet.Protect ' Password:="secret"
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
How to Collect minutes of various meeting into single thread
I need tips and help on how to automatically add data from various minutes of meetings, to a common single thread having all the department minutes in one place.
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?
Next Page