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?
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.
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.
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!
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.
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)
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
It would be fantastic if there was a built in way to group reports by month or year based on a date column. Something in the group settings when you choose group. If you select a date column you would have these options Oldest to Newest by Year Oldest to Newest by Month Oldest to Newest by Day Newest to Oldest by Year…
Sometimes, mistakes happen and someone may adjust column properties, names or other sheet functionality that the owner may not want. Maybe the person who made the changes meant to make them on a COPY of the sheet and accidentally made them to a master sheet (we recently had a similar scenario happen). It would be GREAT if…
I would like to be able to lock a row (and thus prevent editing it's content) WITHOUT locking the ability to add, update, edit, or delete comments from that row. User story: We have a project schedule template with deliverables, milestones, tasks, and dates. The date rows are locked because they are cell-linked to project…
©2024. All Rights Reserved Smartsheet Inc.