Trying to subtract 1 year.

I'm trying to count rows for 2022 in a set of data. Below is the formula I was trying. I have a column called years in the main data that parses out the year from the timestamp. What am I doing wrong?

=COUNTIFS({URV 2 Years Range chem}, true, {URV 2 Years Year}, YEAR(TODAY() - 1))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!