-
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?
-
Automation workflow not including attachments in notification emails correctly
Hi ! I am trying to figure out why some email notifications include attachments and others don't. I have a few teammates who add attachments to the rows when certain columns are triggered by a checkbox. I have my automations set below. And you can see once column was checked email includes attachment, but same email it…
-
Need to Understand Basics
Is anyone a SmartSheets pro that could get on a call with me for no longer than an hour and go over some basics (to you I'm sure) on how this system works? My Launch10 package was used mostly to set up my first sheet and I never had the time to actually learn how to use the system. I have automations set up but there are…