formula needed
I'm new to Zoho after being a Google Sheets user for years... lots of things I despised about Google Sheets... I now find myself missing ONE feature... their script editor... because of ease of use for my "lack of knowledge" in this area... I know enough,
[COUNTIF/SPILL] Trying to find result that fills 2 conditions at once / SPILL results
Hi! I have the following formula from an imported Google Sheet =countifs($B$2:$B; "<>0" ; $D$2:$D ; FALSE)*220 In the B column, I have a list of dates In D column, I have a list of booleans (TRUE/FALSE checkboxes) Opening this formula, we have: Range
how to migrate documents to zoho workdrive
How can i move my files to workdive from zoho docs
How to create a drop down menu in Zoho Sheets
I am trying to find out, how do I create a drop down option in Zoho sheet. I tried Data--> Data Validation --> Criteria --> Text --> Contains. But that is not working, is there any other way to do it. Thanks in Advance.
how to create a pick list
Hello, In sheets, how do I create a pick list? I see it's an option when right-clicking on a cell, but can't see how to edit the choices.
No chat option
Chat option is not available in Android app.
No chat option
Chat option is not supported.
Excels
Sant internette
Ability for admin to transfer the ownership of the zoho sheet file
Currently, in Zoho sheet, there is no option for the super admin to transfer the ownership of the Zoho sheet file to a different user. Suppose if an employee has left the organization then in that scenario we can not access the Zoho sheet files created
How to add url to macro
have an idea how to add the weblink: https://onedrive.live.com/?authkey=%21AHc4H6gbexVr9f0&id=6B86D5C26B3B694B%21156&cid=6B86D5C26B3B694B&parId=root&parQt=sharedby&parCid=BB6DC96E46411881&o=OneUp to the macro?
Tip #7: Four things you didn't know you can do with Conditional Formatting
Conditional formatting helps you highlight and visualize data in your spreadsheet based on provided rules. Zoho Sheet offers three types of conditional formatting: Classic, Color Scales, and Icon Sets. If you're already familiar with how Conditional Formatting works, here are some bonus tips for Classic formats: Customize rules with formulas Zoho Sheet allows you to create personalized rules based on formulas. For example, in a task list you can use customized formulas to highlight tasks which are
How can I insert a row into one sheet automatically when a row is crated in another sheet?
I use a sheet to keep track of service requests that are entered via a public form. One of my customers wants to use an API from their system instead of filling out my public form. They want to directly create rows in my sheet from their system, and we
Build readable, reusable custom functions with LAMBDA()
LAMBDA, the new addition to Zoho Sheet's function gallery, has the potential to change the way you work with formulas in your spreadsheet. The function helps make your formulas more readable and reusable. You can create custom functions that fit your
Zoho sheets into a tab in teams?
Hi I was wondering if anyone knew a way I could display a zoho sheet into a tab in microsoft teams?
Introducing 15 new Zoho Sheet functions
Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient text
Request for access
Hi everyone. Please help me. When I try to access a spreadsheet that a friend sent me by link it doesn't open, it says I'm not authorized to access the spreadsheet. Please help me. Thank you
Will Zoho sheet continue after March 15, 2023?
Hi Team Zoho. I heard that zoho docs will be discontinued after March 15, 2023. I just want to make sure that it is zoho docs but not zoho spreadsheet. Please clarify. Thanks.
Can Zoho be accessed/used in China?
I'm looking for an alternative to Google Docs (Spreadsheet specifically) that can be used in China. Can Zoho be accessed by users in China?
#CIRCULARREF!
How come im encountering #circularref! error. i double checked the formula but they are correct. It seems that the synchonization to the server has an error. Thank you
Perform customized calculations with the new LAMBDA functions!
We released the LAMBDA function in Zoho Sheet in 2021, enabling customized calculations inside predefined functions. Now, we're extending LAMBDA's capabilities with six new functions. Each of these functions applies LAMBDA to the given input, performs
Sheets date format dd-mm-yyyy - time, it seems, is at war with me.
Hi, I'm trying to set the format of a column to the date format we use here: dd-mm-yyyy. Unfortunately, this format does not show up in the options. There's no specification in Settings to specify it either, I can't seem to set a custom format, and while
Custom fonts are not exported in PDF
Hi! When I download my spreadsheet, the custom fonts I uploaded and set are all replaced by the fallback fonts. Why is this happening? I hope this can be fixed.
Issue with API worksheet.records.add
Hello I am having an issue with using the method "worksheet.records.add" I am currently getting a 400 error. As a note, I have successfully gotten an access token (and get a new one every time I start a new session) and have successfully been able to
Named ranges will disappear from the sheet
I encounter this when attempting to delete one or more named ranged from the defined names in the management box. It's hit or miss; some range names that I deleted several times, keep reappearing and others that I wanted to keep will be deleted. When
The opposite of QUOTIENT or a non-destructive alternative?
I hope I'm not asking a too dumb of a question, but I'm trying to use the equivalent of DIVIDE, which according to the Knowledge Base is QUOTIENT. However, QUOTIENT seems to round the numbers down, as if it had ROUNDDOWN applied natively to the result.
Unable to share a sheet.
Hi, i was trying a sheet with some of my collogues, they are registered on Zoho sheets with their email still when I try to share the sheet I get the following error. Share with non-Zoho user? You are about to share this file with @gmail.com who does
Data Entry Form?
https://help.zoho.com/portal/en/kb/sheet/working-with-forms/articles/create-a-form-in-zoho-sheet Is it still possible to create a data entry form using ZOHO Sheet? I referenced the link above and I d o not see this option? Thanks
Can I share my Zoho spreadsheet with others
As a data entry professional, I utilize Zoho for my work and I'm interested in knowing if I can share my Zoho spreadsheet and database with basketballist company. If so, I would like to know the steps involved in accomplishing this task. Any guidance
Restrict access to one spreadsheet
I have a file with three sheets . Each sheet is for a particular individual to enter data. how we restrict the user to view the other individual sheet except the owner
what is the zoho sheet formula equivalent to this google sheet formula?
In the google spreadsheet this is what I have I have forumula in column K: =unique(B2:C) Then I have formula in Column M: =map( filter(K2:K, len(K2:K)), filter(L2:L, len(K2:K)), lambda( model, trim, torow(filter(C2:G, B2:B = model, C2:C = trim)) ) ) When
Disable download, Save As and copy option in sheets
Hi I am a free tier user. I was just testing out Zoho sheets for my use case. I wish to move my data from Google sheets to Zoho sheets. The problem is when I share a sheet with view access only to other user who has a private email like gmail, hotmail
Offline Editing and Access
I can't seem to find how saving your sheets offline works. I don't see a button for it anywhere.
zoho sheet - How do I create a list of values to choose from in zoho sheet
I want users to choose only a value on a list of items (as you can do in Excel). Can I do this in zoho sheet?
Putting Watermark on Zoho Sheet
Can this be done?
Scatter graph when x-axis is time becomes a line graph/chart
The difference between a scatter graph and a line graph is that the x-axis should be mathematical. Ie if the X data points are 1,2,4 , the '4' should be 2 intervals away from the '2'. On a line graph, they would be next to each other and equidistant to
Is it possible to share my Zoho spreadsheet?"
Hello everyone, I am a data entry professional and I use Zoho for my work. I would like to know if I can share my Zoho spreadsheet and database with a wordparadox company. If so, how can I go about doing this? I appreciate any insights and advice. Thank
Tip #15: Stop guessing and start estimating with Zoho Sheet's Goal Seek
Goal Seek is an ideal spreadsheet tool for devising estimates, as it helps you retrieve your desired output value when the input values are not known. In other words, Goal Seek does back-solving to find input values once you've provided an output value.
Editable sheet but can not distribute, save or email or etc...
Is this possible? I want the file to save in its existing location. But not for the user to be able to save a copy etc... this is disastrous. Is this possible? I can see that this has been asked in various forms up to 9 years ago and as far as I can tell
Images Stored in Zoho Workdrive not displaying in Sheet after putting the image URL
I have generated a form from which images are uploaded onto zoho workdrive & the image URL is stored in a ZOHO Sheet. Now when i try to Display the image it shows a broken image link. When I try to go insert Image from the insert from URL, in the dialog
How to add a Trendline to a chart inside sheet?
Hello Zohos I am very please with the improvement of Zoho Sheet since I used it last time Im still missing one thing that I easily have access to in MS excel : Add trend trend line I found a way to calculate the regression line by: =FORECAST =SLOPE =RSQ But I'm pretty confused how to get the line on the chart with the data. Are there any solution to this?
Next Page