-
Conditional formatting for dates that are X amount of time in the past
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. For example, once a record is greater than 5 years old then it must be archived. We would like to easily see when this occurs or be able to create a workflow to move them to another…
-
Export column descriptions
It would be really helpful if we could export column descriptions along with the columns themselves to excel.
-
CONCAT data fields before uploading with Data Shuttle to Create Unique ID field
Data Shuttle needs a unique ID when merging data. Sometimes there is not a single field in the data that we are trying to upload that is unique, but a combination of multiple fields can create a unique ID. There should be a way to CONCAT multiple text strings prior to the data being processed in Data Shuttle.
-
Programatically Collapse All Rows Through the API
Idea: A single command that can be used to collapse all in a smartsheet through the API. How is this done today? by running another script to identify each parent row and then send a command of expand=false. It certainly works but it's not clean or easy. A single command to collapse the entire sheet is needed. Why is this…
-
Print Generated Documents
Can we add the option to print a sheet after a document has been added? It would be setup that same was as "checking" a generated box which would trigger that document to be printed.
-
Better Sorting for Sheet Summary Report
If you have several dates listed in the sheet summary on a project, then you can have an option for those to be pulled onto the sheet summary report not in a row, but all in one column? Then you can sort by the date and it will actually make them go in order? Instead of a row of dates, it would be a sortable column of…
-
Prevent users unsubscribing from automation workflows
It should be possible to prevent users unsubscribing from workflows as these can form part of a process notifying users or work/tasks etc. These users have been setup, they have not subscribed so they should not be able to unsubscribe.
-
Column Level security
Allow only a subset of users to update data in a specific column. Make it group or named based.
-
Widget Behavior Open a Form
Hello Smartsheet, improving the widget's functionality to directly select the Smartsheet Form Name instead of the Form URL would greatly enhance efficiency, especially in Control Center project creation. Currently, Control Center doesn't capture the exact link due to it being an external link, leading to frequent updates…
-
Unlinking access token when an account is deactivated or removed
Using SSO through an IdP currently links an access token to the Smartsheet account. When this account gets removed or deactivated (in Smartsheet) it retains this access token. If a new account is created, or the user changes email and a new account is auto provisioned, then the authentication tries to sign the user in to…
