IF and INDEX functions

browning.m ✭✭
edited 03/03/23 in Formulas and Functions

Hello! I want to call a month cell that's connected to the year we're on (2023) and the past year (2022) but automatically as the years go by. Example, in 2023 I want to know the number that's in the cell that corresponds to that row (january, february...) and also that same information but from the year before (2022). For this, I have created another sheet that brings data from the one in the image below. I think I'll need to have a IF function to add a =YEAR(TODAY()) and a INDEX to pick up the cell, but I'm not sure.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!