YTD Count Based on Open Date

Hello,

I am struggling to get a count of items that have been requested in the current year. I have been going through all the different posts and below is the formula I came up with to count all items that have been requested in the current year. When I run the formula I am getting 0. The dates are populated from a form and the column is set to the date format.

=COUNTIF({Date Requested}, IFERROR(YEAR({Date Requested}), 0) = YEAR(TODAY()))


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!