Column Formula Syntax Isn't Right

System

This discussion was created from comments split from: Getting Message Column Formula Syntax Isn't Right.

Chris Keenan

I'm getting the same error message, and my formula also includes TODAY(). Could you help me understand what I might need to change? This helper column shows 1 when the date is greater than 1 year, and 0 when it's not, which is then used in conditional formatting.

Formula: =IF((TODAY() - Date12) > 365, 1, 0)

David Tutwiler

The problem is likely the Date variable. To use a column formula it needs the @row so it can copy it all the way down. Try:

=IF((TODAY() - Date@row) > 365, 1, 0)

Leibel S

@Chris Keenan

Change to the below (using @row)

=IF((TODAY() - Date@row) > 365, 1, 0)

Chris Keenan

I JUST realized that as I was going over the formula rules again. I also added IFERROR to get rid of the #INVALID in the first two cells in that column. Thanks for the help.

David Tutwiler

Glad it's working.