Is it possible to display formulas in cells instead of calculated results?
I want to export my Zoho sheet as tab separated text without losing the formulas. In excel, I would use the settings Options - Advanced - show formulas in cells instead of their calculated results then save as tab separated values. How do I do this in
How to get NSE/BSE Stock Prices in Zoho sheets?
I've been looking for a function that provides me with the NSE/BSE listed stocks price in Zoho Sheets like GOOGLEFINANCE in Google sheets, but I found none. Please help if there is any way to het stock prices?
Conversion of functions from Google Spreadsheets
Hello! I use this formula "=QUERY(ResumoOrdemVencimento!A3:O38;"SELECT A,B,C,D,E,F,G,H,I,J,K,L,M,N,O WHERE C != '' ORDER BY C,G")" in Google Sheets but when importing my spreadsheet into Zoho Sheets the formula was not converted. The QUERY function brings data from another spreadsheet, and then I sort and apply conditional formatting. The order of data will change automatically as I update the source spreadsheet. What Zoho Sheets function is equivalent to QUERY? I have some other spreadsheets to
Is Drawing feature supported in zoho Sheets?
Is there any option to draw arrows and some basic shapes such as circle , rectangle etc in zoho sheets? if so, can someone help me find it
Collaborative editing of spreadsheets by multiple users simultaneously - Is it really possible?
I work in a SharePoint 2010/SharePoint Server 2010 environment and we use MS Office 2007(Excel 2007) . I have been trying to create a MS Office document which will allow multiple users to work on a spreadsheet simultaneously. For that I have: 1) Created a excel workbook and published as a workspace as suggested by Andrea Kalli in her link: http://www.wonderhowto.com/how-to-collaborate-files-between-sharepoint-and-office-2007-182172/ 2) Set up and saved the Excel Workbook as "Shared" and made it available
Revamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
Tip #19 - Create checkbox tracker in your spreadsheet
Hello Sheet users! We are here with yet another tip to help you get the most out of Zoho Sheet. Spreadsheets can be used to handle a variety of tasks, but ever tried using checkboxes to track the progress of your action items dynamically? Here's a sample
Suppress "spreadsheet will not be saved" message on published sheet
I have published a sheet and have one column on that sheet that the user can edit (a dropdown picklist where the user can select the status for each line). Is there a way to suppress the Zoho Sheet message "Any changes made to this published spreadsheet
Zoho Sheet Custom function column showing Error #EVAL!
Hello I have a custom function in Zoho Sheet developed to convert a date time from one time zone to another. The custom function takes date and time columns and then using subHour( ) converts the time to PST time. However, though the custom function works,
Zoho Sheet-Pulling in Data
I have a module where we track POs, Bills etc (its easier for us this way). In this PO Module, we have a task related to a Job/Deal and various fields for costs. A Supplier on a Job might have several POs in this module for the job. I want to generate
Data not visible in sheet cells
I'm having an issue where my data is not visible in my sheet cells. If I click on an individual cell, the data does display above in the little "fx" box. But all the boxes in the sheet just look blank. My collaborators do not have this issue. I have checked
Stock function not working for Brazil (Bovespa)
Hi, The STOCK function in not working for the Brazil Exchange "Bovespa". This is the syntax I´m using: =STOCK("Bovespa:BBAS3";"PRICE"). Thanks for any help. Ale
use of comma as a decimal separator
Hello, I wish to find a way to customize the number format for my proper use. I have to use french data, where the "," is used as the decimal separator : for example the french way to write "3.99�" is "3,99�" Is it possible to do it in Zoho Sheet ? If this is not actually the case, I'd love this feature to be implemented !
copy the row to the end of table if under condition
Hi, my table is created from zoho forms entry. Lat's say that column 3 has value 1 or 2. when the value is 1, no action is needed but when the value is 2 I would like that entire raw was automatically copied to the next row - it is the end of the table.
Zoho Sheets hide or unhide columns. How it impacts other users
Hi I would like to know, when someone hides a column in the Zoho sheet, the hidden column is also hidden from everyone else that is using the file. The collaboration feature seems to not work.
Syncing Sql Query Table to Zoho Sheets
I want to sync Query table to Zoho Sheets. I already used data connection zoho sheets but the issue I am facing is while it gets synced the data I entered in new columns next to synced columns is getting mismatched as new row data is coming. So is there
Always Match Destination Formatting while Pasting
How do I always match destination formatting when pasting in Zoho sheets?
Zoho Sheet - Desktop App or Offline
Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.
Set print area
Is there a way to set the print area like I can with Excel
How to concatenate to make clickable url?
Hello, When I type url in cell it automatically creates hyperlink. Now, if I CONCATENATE two cells like this A1:http://www.domain.com/ B1:blog to make C1: http://www.domain.com/blog it doesn't create a clickable link. Why not?
Anyone else having a problem with the macros?
After I have made a macro and saved it, I went to the manage section, but it does not show the macro (or any macro) I've made. Suggestions or solutions would be much appreciated.
Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that
The server is unable to handle the formula cells in your spreadsheet
The above warning has come up on the top of my screen. I can't find how to find out what formula is the issue. There is a lot of data in the workbook, are there any limits to the data. I can remove rows if needs be I just need to balance the amount of
zohosheet keep loading and don't know how to fix it
one of my zoho sheet is getting slow. How to fix it.
SUMIF with "=" condition giving #NAME! error
I have =SUMIF(H21:H27;=&B55;I21:I27) which is throwing an error. Have tried =SUMIF(H21:H27;=B55;I21:I27), =SUMIF(H21:H27;"="&"B55";I21:I27) and =SUMIF(H21:H27;"=B55";I21:I27)
How to Avoid Impacting Other Users When Hiding Columns in Zoho Sheet
Hi Team, We’re experiencing a challenge with the column-hiding feature on Zoho Sheet during collaborative sessions. When one user hides a column, it becomes hidden for all users working on the file, which disrupts others' workflows. In comparison, Excel
Workbook Open Trigger executing twice
I have some simple VBA code in the Open trigger for a workbook that increments the open count so I can track how many times a workbook has been opened. However, it appears that it is being executed twice whenever the workbook is opened, as the count gets
Data overlapping error - data connection schedule
Hello, I created a spreadsheet and connected it via data connection to zoho analytics, asking to fetch data monthly from a table in analytics. I want the data in the spreadsheet to be replaced each month with the newest data in the analytics' table. Each
Zoho Sheet - Conditional Formatting - Formatting the entire row
How can I apply formatting to an entire row based on the text value in one cell? I tried it, and it seems to work on that cell itself.
Recent Maintenance
Dear Zoho Sheet Team The recent 'Improvements' gave me considerable problems. I can't evaluate the extent of these problems, they could range from fixable to disastrous. I can't check more then 300 sheets quickly. A lot of my images have suddenly disappeared, this seems to be the major problem. Where have the gone and how can they be recovered? Another thing I noticed - you have taken away the 'SAVE' button. Clicking on 'FILE' doesn't give a 'SAVE' facility either. I will keep working and report
Credit Limit Exceeded in Zia
When I enter any word, sentence, phrase... anything into the AI Bot question box, the only "answer" I get it is "Credit Limit Exceeded." I'm using a paid version. I cannot even search a single word. It gives the same reply. What credits?
Transitioning FESCO Bill Project to Zoho Sheets and Integration Options
Hello Zoho Support, I'm considering transitioning my FESCO bill project from Google Sheets to Zoho Sheets and wanted to know if there are integration options to seamlessly migrate our existing work. You can view our platform here, any guidance would be
Can we share the URL of My zoho Sheets on other websites?
Hello everyone? I have sheets on Zoho and I want to share them on other websites like daraz, homeshopping, gepco duplicate bills, etc. I don't have much knowledge about online sharing question forums? I am a student and have a short survey about online
can I use zoho sheet for survey?
Hi I wanna use zoho sheet for my ARY to know consumer better so i wanna have permission to do so
Grouping rows in Pivot table
Hi, I have created a pivot table with months and total sales for 4 years month on month. I want to group the rows to make it year on year and see the sales number. The option is not seen but it is not highlighted hence I cannot group it. Kindly help.
Set-content-to-row API Call Error
Hello, I created a custom function to set content to row, however, I got the following error. {
error_message : "Internal server error. Please report this issue to support@zohosheet.com",
method : "row.content.set",
error_code : 2866,
status
Sheet Access
How do you set a spreadsheet to only allow certain people to access certain sheets? Like if I wanted to have someone view one sheet that pertains only to them, they can't see the other sheets on the spreadsheet while allowing someone else to view theirs but not others.
Zoho Sheet for Desktop
Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?
Collaborators are not able to upload images
Good afternoon, We have a sheet with 2 current collaborators and when they try to upload an image , a pop up comes up ' server error, there was a problem saving your last edit. Please try again' Can you kindly assist?. Thanks, Annrica
Is Zoho Sheet available for Mac OS ?
Is Zoho Sheet available for Mac OS ?
Next Page