Good afternoon all!!

First time poster on here and still learning my Smartsheet.

Stumped on the formula and looking for some assistance.

I'm trying to count the checkboxes in the 2 columns on the sheet below, SUG Scheduled and SUG Completed.

What I am trying to do is count it each column for each similar column for the sheet below, separated by fleet type.

So for example on the second image, I want it to display for 73N SUG Scheduled, that 6 boxes are checked on Sheet1.

Thank y'all in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!