Counting help

Hi There! I am trying to create a reference sheet to pull data for a dashboard and am trying to figure out how to count instances a item with a certain value is check off. So, how many items checked off of the list are for "Property Info". I've tried using COUNTIF, COUNTIFS, COUNTM and so on, but I can't seem to figure this one out...


Is there a way to tell the formula "If an item is checked off and is tagged as 'Property Info' count it here"

I want to be able to show a quick snap shot of how much information has been received and how much is outstanding.


I did add hierarchies to maybe help keep the data accurate if lines are added...

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!