Hello, I hope someone can help me out here.
I have a spreadsheet with a column called Date Highlighted. The format is m/dd/yyyy. I have this expression:
=If(Year([Date Highlighted]) = 2021, 'green()', white())
My thinking is that if the year is 2021, then the row should be green, otherwise it's white. However, all rows are white. Can someone tell me what is wrong with my expression?