Is there a better way???
=IF($[Year Select]$2 = "2023", @row, "" + IF($[Year Select]$2 = "2022", @row, ""))
I am having an issue where I can select 2023 just fine, but when I select 2022 all of my reference dates change to a "Text date" and the formula in the data 1 & 2 columns do not recognize it.
Is there an easy way to fix this?
Or, is there a completely different way I should have this set up?
I only have a couple months of any spreadsheet experience and am open to any and all feedback, Thanks!
Help Article Resources
Check out the Formula Handbook template!