Progress Bar Formula

Hannah McHardy

Hello,

I want to create a formula that changes the Progress bar to full when the Status column is changed to Complete. I don't want a formula for any of the other Status options.

Thanks in advance.

Andrée Starå

Hi @Hannah McHardy

I hope you're well and safe!

Try something like this.

=IF(Status@row = "Complete"; "Full")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Hannah McHardy

I hope you're well and safe!

Try something like this.

=IF(Status@row = "Complete"; "Full")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Hannah McHardy

Hi and thank you for responding.

Formula is perfect, I was trying something very similar with no luck.

Slight issue, I've made it a column formula which has changed all of the other progress bars in the column. How can I make it so it only effects when an item is complete? Or should I use a formula for all of the progress bar options (Employ, Quarter, Full and Three Quarter).

Thanks,

Hannah

Genevieve P.

Hi @Hannah McHardy

I was searching for something else and came across this post - did you figure out how to build the rest of the formula?

You're correct, you would need to create a rule for each of the levels of progress for the bar, identifying when it should be Full, Empty, etc. This would be a nested IF statement, similar to how you'd change a status ball colour.

If you still need help, it would be useful to know what the criteria is for each individual bar option.

Thanks!

Genevieve