-
Allow an option for some filters to be Live
Currently, there are sheets where filters are used to eliminate certain cards. However, as filters are not applied Live, disabling then re-enabling the filter is the only way for it to apply to the sheet. I would suggest having an option in the custom Named filters to enable that filter to be Live. From a product and…
-
Add HTML formatting in Automation Workflow Notifications
Would be great if we could force wrap text within an Automated Workflow Notification Alert "Message" using </br> HTML tags, and/or be able to <bold> text directly within the Message we're setting up. Hoping this can be an enhancement one day to Smartsheet.
-
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…
