-
Cascading Forms
Cascading Form data sets is one of Smartsheet's missing capabilities that I believe would be a game-changer for many alternative providers. Cascading forms are a very effective technique that can be used to compress form data and limit down options in order to narrow a workflow or collect more accurate data. Recent usage…
-
Publishing Sheets with set Filter
We would like to publish and share a sheet with a set filter so that when the sheet is opened with the shared link, it keeps the saved Filter. When the sheet is open you can see all shared filters, but we want to make it easy for team members to open the sheet and already see the filter we have saved for them to view.
-
UPPERCASE text on entire sheet without formulas
Having to have helper columns for every column in a sheet with formulas to change all text to UPPERCASE that is input through a form from other people makes my very large sheet ridiculously and needlessly larger - and then there is the problem of data shuttle which does not shuttle columns that contain formulas, so you…
-
Assign multiple placeholders or a combination of named people and placeholders to a row
For sheets connected to Resource Management I want to be able to assign a combination of named people and placeholders or multiple Placeholders per row. I am using Resource Management with Smartsheet to track people and equipment assigned to tasks. Both the people and equipment are 'managed resources' in Resource…
-
Run Config Window for Data Shuttle
When you run a DataMesh, a window Run Config window appears that shows the number of rows that will be impacted for different types of things (i.e., New Rows). It would be helpful to have this for Data Shuttle as well. On more than one occasion the unique identifier mapping unexpectedly un-maps, and all the rows are…
-
Resetting Auto-numbering for columns in templates and sheets
Problem: When creating a template from another sheet with an column set to type auto-number, I have learned through technical support that you only have ONE chance to reset that column back to start number 1, and only by deleting the old column and creating a new one. If you make a mistake with the numbering schema, you…
-
Sheet Properties / Metadata - Column Count
Rows are numbered but columns are not. There should be sheet metadata available thru File / Properties that tells the user how many columns are in the sheet. This would be helpful for solution developers to know if they're approaching the 400-column limit without the tedious and error-prone task of counting them manually.…
-
Data Mesh Auto Map columns with identical names
if I'm using 36 columns in source and target sheets I have to touch all 36 columns in both parts of the Data Mesh Column Mapping. IDEA: if the column names are identical in both places, auto fill / match columns similar to what data shuttle does.
-
Data Mesh Multi-Column Match
I think it would be beneficial to have a multi-line match option within a data mesh instead of having to setup 2 different configurations. For example, attempting to match the values in two columns to meet the criteria to proceed would help if you happen to have a few duplicates in one of your columns, then the secondary…
-
Folders for Data Shuttle Workflows
I have many D.S. Workflows and would like to save them in folders for each sheet their tied to. This way I don't see all the workflows in a long list