# Formula on checkboxes

Options

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.

Tags:

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

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

• ✭✭✭✭✭✭
Options

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?

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

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

• Options

Awesome! Thank you. Take care

• ✭✭✭✭✭✭
Options

You're more than welcome!

Be safe!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!