Use countifs to count all projects with a quarter date and year from a date column

Options

my current formula is =countifs({sheet reference}, ROUNDUP(MONTH(@cell)/3) = "4", {sheet reference}, Year(@cell) = "2022"


I have ensured the column from the reference is a date column, however I am given invalid data type as an error

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!