CountIfs question

I am trying to write a formula that Counts the Active projects for Q1. I have a column titled Quarter and each quarter is labeled Q1, Q2, etc. My formula says =Countifs({(Sheet name Range 1)=Q1)} and I'm getting an #Unparseable error. Any suggestions?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!