-
Hidden Cell in Form not populating in Smartsheet
I have got about 18 forms that are all the same except for one field, this is a hidden field that identifies which shop is completing the form. The field is a dropdown option but in each form the default is the shop I need it to be. We have used this for 3 years and all of a sudden this morning, that field isn't populating…
-
If the checkbox is checked copy the row
I am having issues solving a problem. I have a sheet containing multiple columns (3 text/number, 1 date, 1 contact list, and 1 checkbox). Made out of around 150 rows. I want the rows copied to another sheet if the checkbox is checked. I tried: Using a copy row automation which works but rows are always copied at the end of…
-
Sorting by Dropdown Order (in Reports)
please tell me that I can also "Sort by Dropdown Order" (in a report)? I know you can do it in your sheet when you are in "Table View" however, I have a report that I need to sort by this column (drop down) and because of alphabetical rules: Draft Protocol not Rec'd (13M) comes before Draft Protocol not Rec'd (9M) HELP!
-
How to create a unique number via formula or how to autonumber via formula due to existing autonumber type column?
All, The way my Smartsheet workspace works: Every time the Status column of a particular request in Master sheet is changed, the entire row is automated to be copied to Status Tracking sheet. The change is timestamped as Change Timestamp and the Subsequent Timestamp is recorded in Status Tracking sheet with every…
-
Importing excel with a column containing Hyperlinks into Smartsheet
I have an excel that contains values that are hyperlinks constructed with Hyperlink construct. for eg: =HYPERLINK("https://docs.oracle.com/en/cloud/saas/readiness/common/26b/common26b/26B-common-wn-f43843.htm","Multifactor Authentication (MFA)") When I import that into smartsheet, all the values read #UNPARSEABLE. I see…
-
Board View Report Without Giving Users Access to Sheet
We have a Smartsheet form where users can request a certificate of insurance. Their email address is recorded in a contact field. I've created a report that filters the contact field to the current user. We'd like for them to be able to see the report in board view, but only for their requests, and do not want to give them…
-
Sheet Summary changes overwritten by other users - can this be prevented?
I have a sheet that has sheet summary values I occasionally need to update the formulas for as factors change however I've found that when other users are updating the sheet (it's a testing sheet) the changes I make to sheet summary formulas are overwritten as those users update their test statuses. Aside from making the…
-
Attached Files not Opening
Over the past year, we’ve had a handful of instances where an image is uploaded to a row for review using the same file type, by the same person, and with the same specs as many other uploads—but after uploading, no one can view or download it. A thumbnail preview appears, indicating the file was uploaded successfully, but…
-
Field View Settings in Boardview Conflicting view
I am having issues with the field view settings within my master sheet as an admin. I try to turn off items that are "shown on card" and they continue to show up. Then when i login as a view only account i do not see all the fields.
-
Lost access to Smartsheet Data
I have not used Smartsheet for several months and my subscription expired. I now wish to resume using it but all my folders nave disappeared. Is there any way of retrieving them?