-
improvement opp. on "convert to column formula"
the current smartsheet will give an error if the formula with "$", for example: if i want to convert one cell formula with "$[A]$1 + $[B]$2"" to column formula, it will give error unless you remove all the "$" in the formula. this should be changed.
-
Dashboard Enhancement: copy & hide elements to share externally
Hello Smartsheet Product Team! Is there anyway we can get a feature where folks can create one dashboard and then be able to make a copy and hide elements of the dashboard to share externally with customers without having to update and / or create copies of the underlying sheets and reports? That would save a TON of time…
-
Macro Switch on Sheets
On Excel, you have the ability to create "Macros" which enables you to do time-consuming/repetitive tasks with a simple click of a button, within the Developer tab and then Visual Basic. For example, you can create a Macro in Excel which will automatically export the sheet, with the format you want for Excel, instead of…
-
Add ScribeHow iframe embed codes to dashboard web widget domains
Our organization has started using ScribeHow, and it is awesome! We are saving tons of time on creating instructional documents. We would love to be able to embed those "scribes" in Smartsheet dashboards, but the domain isn't included in those that can be embedded in a web content widget. scribehow.com
-
Ability to Change Column Type When Conditional Formatting Exists
I would like to be able to change column types without having to delete conditional formatting rules. Currently I have 20 columns that I want to change from Text/Number to Dropdown List. They each have 5 Conditional Formatting rules applied to them. I can't change the column types without deleting the rules first. I can…
-
Auto-Update Report Column Names
This is a request to automate updating the report columns when the underlying sheet's column name is changed. After the new Smartsheet release that connects the old column names with the new ones, there are more clicks required to update the report's column names. The extra step is having to disconnect the old name from…
-
Segmenting within Grids
It would be really helpful if Smartsheets allowed segmenting to provide the ability for formatting by cell or segments. For example, have the top segment of a Smartsheet have columns with formatting by contact names, and the bottom segment be a list of values, associated with the contact names in the rows above. Format…
-
Reference Comment in Formulas
Please add functionality to address comments via formula, such as =countif([Comments]@row, "No Change") to simply count how often in a row a project is listed as "No Change" or how often something is commented on with =count([Comments]@row). This would add functionality for tracking KPIs and Leading Indicators which is…
-
Add ability to change text color when using "highlight changes"
The formatting of our templates includes summary / parent rows that are white text on a dark background. When highlight changes is turned on, it makes some of the text unreadable. I am not aware of a universal setting to change all highlight changes to another color but yellow... I think its a per sheet setting? Bening…
-
Simple Iteration
Please add iterators either from workflows or cyclic cell reference. For example if I wanted to increase a cell named [Count] by 1 every time a checkbox named [KPI] is checked, I could write a formula into [Count] such as: =if(KPI@row, Count@cell +1) and then set a workflow to uncheck KPI. This could also be done with a…
