COUNTIF AND for date

Referencing when a column says HR and the date is this year

=COUNTIF({Intake Archival Range 1}, "HR", AND({Intake Archival Range 3}, >=DATE(2022, 1, 1)))

Any help appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!