Count if formulas

Amanda Thacker
Amanda Thacker ✭✭✭
edited 12/09/19 in Formulas and Functions


I have a fairly simple formula that I need assistance with.  I have a 'Date completed'  column (UK Date format) and a check box column, 'Test1'.  I want to do a count in a separate cell for all the rows that have check boxes ticked for within specified month period.  E.g. Count the number of test completed in May.  I will be linking to a separate sheet but should be able to work that in with the assistance of smartsheet.

Thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!