-
Ability to reorder list of sheets in left menu
When I am working on a sheet, every time I want to go to a different sheet I have to sit and study the list to find the one I want to go to. It is a waste of time and very frustrating. It would be SO helpful if I could put the list of sheets in the order I want them in. And have them stay in that order, unless I move one.
-
Delay between Sheet and Report
I have several rollups and am having trouble today where when something is updated on a sheet it is taking quite a while to update across to my rollup reports. I noticed this when I added a dropdown option and again when I received an email update about a new item. I could see the item in the sheet but not the rollup. I…
-
Setting Alerts At A Row Level Using A System Column
We are trying to set up the sheet so that when a particular task is checked off as "Received or Done" it sends an Alert to the correct team member. We have a systems column to allow us to set it up to be row specific to the task, but it isn't working. Please see the screenshot below. Thank you in advance for any help…
-
Adding Rows in a sheet
When adding rows to a sheet, why does the Dashboard graphs not recalculate the graphs with the new rows? Seems the only way to fix this is to back in the graph and select the new data rows. Am I doing something wrong? Thanks David
-
sheet ownership transferred over without owner accepting request
Someone who I made admin of a sheet I created was able take ownership of this sheet without me accepting the request. This has happened before without even a request submitted to take ownership and I don’t understand how is this possible, did anybody experience this as well? The same admin was able to take ownership of…
-
cannot download attached files
The sheet that I have shared with a colleague has attached mp4 files but he cannot download them. The download option is grayed-out. His permissions are set to: Editor-can share. When he clicks to download, it asks him to log in with his Google account (as shown in the screenshot). Does anyone know how I can change…
-
Grouping Tabs
Sorry if this has been asked and answered, but..... Is there a way to have all the sheets in a workspace (or by some other means) open simultaneously (think excel "workbook" with mutiple "worksheets").
-
Linked Cells with Numeric Value not working in Chart Widget
Hi, I have a roll up of numbers for the total of checkboxes checked off in our main data sheet. I've linked that totaled value into a separate sheet via the link cell capability. That is somehow not getting charted, and is showing up as "Invalid data"? What am I doing wrong?
-
API for linking MS Excel to SMARTSHEET
Greetings I am handling a number of projects and making Gantt charts to track their progress. The data for these charts are stored in MS Excel sheets on my local drive. It becomes cumbersome to manually import the dates and numbers to update the Gantt chart. I want to know, if there is way I can circumvent this problem. I…
-
VLOOKUP is data type of TEXT instead of DATE - sorting is off
I am currently creating an report which looks up dates based on specific milestone tasks over a number of project sheets. When the vlookup calculation is entered and I hit the Return key, is it giving me an alert that the value is not in date format. Being the admin, I am able to override this. But when sorting, it sorts…