Formula on checkboxes

Jona Gjylameti

Hello all,

I am trying to find a formula that will show me progress based on 3 or more columns that are checkboxes. I want to show progress if one of them is checked, I want this new column where the formula will be to say not started if all are not checked and completed if all are checked. Can this be done? I tried to come up with something but haven't been successful. I need the formula under the Status column.

Andrée Starå

Hi Jona,

Try something like this.

=IF(COUNTIF([Training 1]@row:[Training 3]@row; 1) = 3; "Complete"; IF(COUNTIF([Training 1]@row:[Training 3]@row; 1) = 0; "Not Started"; IF(COUNTIF([Training 1]@row:[Training 3]@row; 1) > 0; "Progress")))

The same version but with the below changes for convenience.

=IF(COUNTIF([Training 1]@row:[Training 3]@row, 1) = 3, "Complete", IF(COUNTIF([Training 1]@row:[Training 3]@row, 1) = 0, "Not Started", IF(COUNTIF([Training 1]@row:[Training 3]@row, 1) > 0, "Progress")))

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?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post 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å

Ok.

No, you don't need to include all criteria, so you can use three of the options if you like.

Andrée Starå

Hi Jona,

Try something like this.

=IF(COUNTIF([Training 1]@row:[Training 3]@row; 1) = 3; "Complete"; IF(COUNTIF([Training 1]@row:[Training 3]@row; 1) = 0; "Not Started"; IF(COUNTIF([Training 1]@row:[Training 3]@row; 1) > 0; "Progress")))

The same version but with the below changes for convenience.

=IF(COUNTIF([Training 1]@row:[Training 3]@row, 1) = 3, "Complete", IF(COUNTIF([Training 1]@row:[Training 3]@row, 1) = 0, "Not Started", IF(COUNTIF([Training 1]@row:[Training 3]@row, 1) > 0, "Progress")))

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?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post 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!

Jona Gjylameti

Hi Andrée,

Thank you for the formula, it's weird how the one with semicolon doesn't work in US but the one with comma does.

I hate to be a pain but I wanted to see if I can use symbols to show this progress. Besides the Yellow, red and green do you know if we can use the ones that have "Empty, half, quarter and full"? This one is the progress bar and it doesn't seem to be working for me based on the formula.

Thanks again and stay safe

Andrée Starå

Happy to help!

Yes, the formula are a little different dependent on region.

No pain, no worries! 😉

Yes, we can. We need to write in out exactly as what it's named, "Full" and so on.

What formula are you using?

Jona Gjylameti

I'm using yours now, but I am afraid the one with Full, Empty and half will need 5 criteria and I just want to show progress as in full and eliminate Quarter or three quarters

Andrée Starå

Ok.

No, you don't need to include all criteria, so you can use three of the options if you like.

Jona Gjylameti

Awesome! Thank you. Take care

Andrée Starå

You're more than welcome!

Be safe!