Current year formula

Hi Everyone,


I currently have a sheet that populates mostly 2020 data. But we now would like to start integrating reports for 2021. Every individual formula has criteria for 2020, which I will now have to change 1 by 1 to 2021.

I have an old excel sheet that allows me to change the year in 1 single cell, and then all formulas will change to report for that given year. Is there a way to do this in smartsheet?

Example of a formula I am currently using:

=COUNTIFS({Environmental Incident Tracking Range 3}, "1", {Environmental Incident Tracking Range 1}, "Leak / Fuite", {Environmental Incident Tracking Range 7}, =(2020))

Snip of the sheet:

TIA

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!