Combinations of seperate checkbox in rows activating a single count


Hello team!

I am trying to categorize 4 different types of work and then also capture how much of each type of work we are approved for. I have four seperate columns of check boxes for different types of work and then a fifth for if the work is approved. the rows have the specific data for the specific work. How can I compare Column A (type A work) as true AND Column I (approved checkbox) as true to create one "count" in my analysis cell? Example: Work type A gets quoted and check box is selected as true (data captured) then work is awarded and awarded checkbox is selected. We now have data on how many of that type of opportunities we have, and how many were awarded to us.

Thanks ahead of time for your help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!