Count boxes checked based on specific data in another row

Nancy Heater
Nancy Heater ✭✭✭✭✭
edited 08/20/21 in Formulas and Functions

Hi all!

I have columns labeled "Inside" and "Outside" that are check boxes.

I have another column for "Install Status".

In my Summary data, I need to count the number of Status that are "Complete" that are checked for "Inside", and the number of "Complete" that are check for outside.

I tried this but is not working:

=COUNTIFS([INSTALL STATUS]:[INSTALL STATUS], CONTAINS("COMPLETE", @cell), (INSIDE:INSIDE, =1))

Testsheet link: https://app.smartsheet.com/b/publish?EQBCT=2a8f00cc49eb4021916f06af91e28095

Thanks in advance for the help, as always!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!