count if and distinct
I would like to get a count of how many checks for the column RTO Wave is checked and belongs to a certain person in the GRE Mgr column (for ex: use John Doe) I have tried using count ifs and distinct count and I am getting errors for unparseable, incorrect argument etc. Appreciate the support. Thanks
Answers

Hi @Catherine Shea. Try this:
=COUNTIFS([RTO Wave  GRE Checklist Required If Checked]:[RTO Wave  GRE Checklist Required If Checked], =1, [GRE Mgr]:[GRE Mgr], "John Doe")
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!