-
Conditional Formatting - Format based on comparison between cells not a Helper Cell
If I want to apply a conditional format to Column B on the proviso that Column B is greater than Column A, I must use a Helper Cell to determine if this is True or not. Like Microsoft Excel does; by including the ability to specify a formula to ascertain whether a Format should be applied would be a lot cleaner than having…
-
Create static Document Builder mapping for project implementation
Our company recently created a cybersecurity threat assessment as a required template for our PMO to ensure that all projects have the proper security and oversight. After working with stakeholders to fill out the sheet, PMs are marking a checkbox on the sheet that ultimately triggers the Document Generator automation to…
-
Exchange rate lookup
Smartsheet needs a live exchange rate lookup such as =GOOGLEFINANCE(“CURRENCY:SourceCurrencyTargetCurrency”)
-
DataMesh - Make it NOT Case Sensitive
I'm having issues with DataMesh - specifically matching emails - because case matters..... I could really use a setting that allows me to specify whether I want case to matter (or just make it not case sensitive) when matching values from the source to the target. Please, oh Please!!!
-
Export entire column of images with each image file name referenced a particular column of text.
I am looking for a way to export an entire batch of photos from a particular column, but name each photo exported with the text in a particular column of my sheet. This is to properly distinguish each photo using its name once exported. Alternatively, I would like the ability to name the image within smartsheet prior to…
-
Lock Document Builder for Viewer Level Users
We autogenerate many of our customer level forms. Unfortunately, a team member who only has viewer access to the underlying Smartsheet accessed document builder, used the incorrect template to create a form and shared it with our customer. We have workflows in place to create the forms when the necessary information…
-
Conditional Formatting Referencing Other Columns
I would like to see conditional formatting rules that can be applied to other columns. For example, we have two columns for each of our KPIs. One column reports the target turnaround timeframe. The other column reports the actual # of days it takes to complete an item. For our surveys, our target turnaround timeframe…
-
Option to remove zeros from Scatter Charts
When using a scatter chart any value of 0 is plotted on the axis. It would be great to have an option to toggle off displaying these values. It crowds the scatter plot with junk information. Here is a before and after example where I use a formula on the metrics sheet to change any zero values to null values. With 0 Values…
-
Email all users in a Group from Group Management
There should be a mechanism to e-mail all users in a Group from Group Management. This would be helpful to send a message for something that affects all users in the group.
-
Dropdown List option to hide 'Select All'
If a dropdown list can have multiple values in a cell it adds an option to 'Select All'. There should be an option the in properties to hide this where selecting all values makes no sense.
