Formula Help


Looking for a little quick assistance. Not sure why I can figure this out, but I guess I'm just not as intuitive with the SmartSheet logic.

I have a metrics sheet that I am using to provide data from other sheets to populate a dashboard. I currently have this formula and similar formulas that pull data within a given year:

=COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

This issue with this is that once the new year comes, all of my data will go away. How do I make this pull information from "2018?" I assumed it would be ...YEAR(2018), but that's not the case. Any help is appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!