Referencing Other Sheets & Summing Text & Checkboxes

Hello Again!

I am looking for the formula to sum text and value, but from another sheet. I tried using a previous formula that you guys helped me with but I can't get it to work.

I need to count the number of LM techs, Sub techs, and teams for a given job. The formula in the highlighted cells should return the number of techs assigned on a different sheet:

The sheet I am referencing looks like this:

If the text in column "FW 37" is "Cardinal Point" AND the check box in "LM Tech" column is NOT checked, it will return a "0".

If the text in column "FW 37" is "Cardinal Point" AND the check box in "LM Tech" column IS checked, it will return a "1". In this example, I should have "0" LM Techs and "3" Sub Techs.

Hope this makes sense! I can never tell if I am explaining all this correctly.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!