Smartsheet TAM confirmed for me that we can't have an Automation change a cell value if the column type is a checkbox for the icons for either a Flag or Star. Can this be an enhancement request?
Sign in to see the current vote count, add your own vote, or leave a comment.
+1 for this idea!
This is a no brainer, hopefully this gets implemented. 😃 Great suggestion.
Agreed Star/Flag may have other significance on a sheet but it should be a checkbox option for automation. Can we please get an update on this fix. (I am working in gov version so I would hope the fix would be for all versions)
The Checkbox column type is effectively a 'Boolean' (i.e. 1/0, true/false, on/off) type of column.
Whether it is displayed with a blue tick in a box, a red flag, or a yellow star is a matter of style/format, etc.
It SHOULD NOT affect its treatment (inclusion/exclusion) in Automation actions. I agree with @Nathan E, this is more of a bug than a feature request. And I agree with @sheetsmartsarah, that they are used differently: • blue Checks for something you actively want/have switched on, or to indicates a positive condition • red Flags for things you actively don't want/require, have switched off, or to indicate a negative/error condition • yellow Stars to highlight or include something, or not
@Genevieve P. , can we please have this 'anomaly' fixed? This problem has been raised multiple times in different threads and should be treated as a correction of errant behaviour, not treated as a product idea for improvement that has to wait for the next roadmap update. A Product Idea for improvement would be to allow multiple Change Cell or Clear Cell actions to follow each other, like some of the other actions.
@Andrée Starå, @Paul Newcome, could you please get behind this and help vote up/support a Product Fix?
Bumping this as a continuing bug. What's even crazier than this not being treated as a simple boolean in the Action of an automation is that it is treated as simple boolean in the Condition of the automation, even as a flag or star, which means it's probably literally just a line of code that's not being copied over. For now I just resigned myself to my checkbox fate and the automation allows it. 😑
It would be great to have the ability to set up a change cell value automation on a checkbox column when the style of the column is set to either a star or flag. Currently, the change cell value automation only works on checkbox columns when the style is set to a box. And if you have a change cell value automation already set up on a checkbox column and then change the column to display as a star or flag, the workflow will become disabled.
Hi, I also have this issue.
Smartsheets, can you please update this?
Would also appreciate this. It is a little annoying to do the formula.
This seems like it would be simple to fix since the checkbox already works…
Please allow the templated workflow automation for "change cell" to include columns that are formatted as symbols. Screenshot below.
Example: When I populate a "completion date" for a task, I would like the symbol column to AUTOMATICALLY change to blue, representing completion.
These "heatmap" style visuals have become more critical, especially b/c people tend not to read and they want to look for colors….red, is urgent/needs attention. yellow is risky, green in on schedule and blue is completed. These seem like fairly standard things.
i doubt this will ever "Come to fruition" since the last update was in late 2023. Guess we just have to use our own tricks (formulas/helper columns etc.) to create this simple/basic request. 🙄
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
