-
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…
-
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.
-
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…
-
Merged: Global Update Find/Replace & Sheet Summary
This discussion has been merged.
-
Merged: "Save and continue" option in the form submission
This discussion has been merged.
-
Possible to change the Resource Allocation End date in bulk for one project.
We have a large number of resources for multiple projects. For us, it's very difficult to change the allocation when the project date has been changed. If you can work on this, we can extend the resource allocation end date in one way for all the resources in the single project, which will help us minimize our effort for…
-
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…
-
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…
-
Merged: Monitoring sheet limits Idea
This discussion has been merged.
