Sign in to submit new ideas and vote
Get Started

Automation to allow Cell Change for Checkbox "Flag" or "Star"

Erica L.
Erica L. ✭✭✭✭

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?

29
29 votes

On Wishlist · Last Updated

This is a good idea. Our team is investigating to see what it would take to enable this. When we believe we can make this idea a reality, we'll plan to update the status here.

Comments

  • Enable Cells with Checkbox Styles as Flags or Stars to be changed similarly to how cells with "Checkbox" styles are able to.

  • What actions need to be taken to enable it? My automation builder will not even recognize Flags or Stars Checkbox columns as options for automation.

  • Mary Wall
    Mary Wall ✭✭
    edited 10/03/23

    I just spent several hours trying to figure out why i couldn't find a field when setting up a change...Finally called tech support and after several minutes of trial and error the support person advised it was because my field is set up for a star and not a check. For the love of all that is holy, if you allow users to make checkboxes stars or a flag, please allow users to set up automations to "check" the star or flag the field!

  • Nathan E
    Nathan E ✭✭
    edited 05/09/23

    Currently, if you are building smartsheet automations, you can toggle checkboxes programmatically using the "Change Cell Value" box. But bizarrely if you set the checkbox to display as a flag or star, it is no longer listed as a changeable value. As a developer, I consider this more of a bugfix than a "feature request," except that I think someone actually decided to restrict the functionality. Regardless, it should be changed. Sometimes a flag or star is more appropriate, and you still need the function to work.

  • Dental
    Dental ✭✭

    Yes, you can change the cell value for a checkmark box between checked and non-checked -- great

    You can update the cell field to any text (i.e, "need updated copy" when X-field date is in the past) if the value needs to be changed -- getting there

    However, you can't format the field or text color to anything (i.e., change to red to indicate immediate action is necessary) when the value is changed -- GRRRRR

    The only way around the problem I've found is two-steps: (1) change the value via Automation, then (2) create a conditional formatting for the desired value(s)