Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

I am trying to count how many dates have a specific YEAR in a cell for a given row...

✭✭
edited 04/05/22 in Formulas and Functions

=COUNTIF([Date of first absence]:[Date of first absence], YEAR(@cell) = 2021)



It keeps giving me #INVALID DATA TYPE

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions