-
HeatMap & Workload tracking Permissions
Current Unmanaged users can see all assignments for the resources they type into the Assigned To column by then viewing the Workload schedule. This contradicts the security permission available in Resource Management ie Portfolio Editor which provides a level of security for resources only having visibility of projects…
-
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.
-
Download for individual/group of rows/proofs
I work with many teams on this application and I always get asked the question "Is there a way to download comments from individual proofs or rows?" and the only answer I am able to give is no. The sheet offers an option of downloading/exporting the entire sheet to Excel but not individual rows or proofs. I have been on a…
-
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.
