-
How can I obtain the URL for a form that is attached to a sheet ?
I need to obtain the FORM URL that is associated with a sheet that is copied via API so that I can populate the URL in a cell. I was reading over the API documentation and cannot seem to find where this is possible. I know this has been asked sporadically and apologies for the duplicate asks, but this seems like such a key…
-
Add custom sort button to ribbon
I have a sheet that uses all three tiers of sorting (and could really use a fourth). Every time my sheet updates with new content from its linked form, I have to re-select each tier for the sort. Excel saves the last custom sort, so, even though neither has an automatic sort capability, you only have to do a couple clicks…
-
Smartsheet API - Is it possible to create a copy of a sheet and maintain the row and column IDs?
Is it possible to use the Smartsheet API to create a new sheet from a copy of an existing sheet, but maintain the row and column IDs? Ideally the output would be 2 sheets with unique IDs, but the row and columns within each would have identical IDs
-
I want to be able to hide my formulas from being viewed when you hover over the cell.
I have a sheet that has a lot of complex formulas and is used (and edited) by many users. When the users are referencing the sheet, the formulas show up and get in the way of reviewing the data. Is there a way I can hide the formulas from popping up when others are using this sheet to edit? All of the columns with the…
-
Is there any way to retrieve data that was deleted from a sheet?
If a grid sheet had 1879 rows of data in it and all of those rows were deleted, is there any way to get all of the deleted data back after it's been saved? I tried looking at the Activity Log but it doesn't show the data and I need it restored in the columns it belongs to. Is this possible?
-
After filling the form, no data income on the Sheets
WHAT's wrong? I created few sheets, just one sheet with this issue.
-
Back-to-back searches from one Ctrl + F
In excel, if you do not exit out of the search window, the cursor stays in the search bar, and you can type a new search criteria without having to exit then ctrl + f (and actually it highlights the search criteria, which is even easier, because you can just start typing your next search without having the clear out the…
-
Control Center - Blueprint Permission setting for "Commenter"
We are able to set the sheet level permission "Commenter" for specific blueprint template, but we'd also like to be able to set up "Commenter" permission to certain User Group in Blueprint setting > Permission > Advanced. However, I only see these choices and no Commenter. Can you please add this choice so we don't have to…
-
Sheet API - Identify if sheet is created from Project template
Hi, Is there any way we can identify if a sheet has been created using Project template (default pre-existing Project template on Smartsheet) or not using APIs? Thanks, Aditya
-
Disappearing Rows
I have what I hope is a basic problem. One of my users has a fairly uncomplicated grid the she uses to keep track of submissions. When she adds new rows, they disappear upon saving the sheet. When I look at the sheet, I can see the new rows, but she can't. She has tried restarting, logging out and back in again, and…