Fiscal Year Formulas
Options
Hello- I am looking for a way to view smart sheets year over year. How do I look at current year and then previous year? ETC? is there a formula to select certain year I want to view.
Answers
-
You can utilize YEAR Function to pull data from particular years. I have also used greater than and less than specific dates in formulas to pull data either would work.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!