I have a date column that I need to check for year value. And if date is in 2023, return a value from a numbers column. I have this set using this formula:
IF({Start Date} < 01/01/2024, {Numbers}, “”)
However, if that date column is empty, I need the new formula column to be left blank, rather than returning the Numbers value. How do I add this to my formula?
Hi Armanda,
The following syntax should work, no matter there is a date in your column or not:
IF(YEAR({Start Date})=2023,{Numbers},"")
What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.