Automate the progress bar (symbols)

Audrey Howard

Hello,

What I'm hoping can be added as a function of smartsheet is adding symbols (specifically the progress bar, but the color dots could be another easy one to automate too) in automations. As of right now, the automations can have the result be changing a cell to a certain value, but Symbol columns are not a type that are allowed to be automated. I would imagine it wouldn't be too difficult, since the symbols have names for each symbol already, and they can be input into a formula, so it should be simple to have an automation that goes along the lines of: 'when 'done' checkbox is checked> change a cell 'Progress'> change to 'full' when triggered.

Thank you!

Jason H

Hi Audrey,

I hopefully digested your ask properly and if so, this formula I use to change the Harvey ball symbols, might be an option for you. I wanted the Harvey ball symbols to change based on % complete column & the finish column.

Here is the formula

=IF([% Complete]20 = 1, "Green", IF(TODAY() - Finish20 > -1, "Red", IF(TODAY() - Finish20 > -3, "Yellow", "Blue")))

Here isa breakdown of the formula

• I wanted the Harvey ball symbols to change based on % complete column & the finish column.
• If % complete is 100%, green // IF([% Complete]20 = 1, "Green" //
• If today is 3 days from actual finish, and not 100%, yellow //IF(TODAY() - Finish20 > -3, "Yellow"//
• If today is after actual finish, and not 100%, red // IF(TODAY() - Finish20 > -1, "Red" //
• If parameters above are met then, blue (good to go) // "Blue" //

I hope this helps!