Can someone tell me what is wrong with this formula:
= IF(TODAY() - ["DUE"2] > 0, "Red", IF(TODAY() - ["Due"2] > -3, "Yellow", "Green"))
I am trying to compare today to a due date and return the appropriate ball.
Thank you.
Deborah,
1. Column name references require the square brackets [] around them if the name contains special characters, spaces, or ends in a number.
2. If the actual column name does not contain quotation marks, you should not use them.
"DUE" is a valid column name if the name really has quotes around them.
If the name is just Due, then no quotes are needed to reference it.
Side note: Column names are case-insensitive, so DUE and Due will be changed in your formula after you type it to the correct case to match the real column name.
3. Cell references are ColumnRow like this: Due2 or [Due Date]2 but not [Due2]
I think this may be what you are looking for:
=IF(TODAY() - Due2 > 0, "Red", IF(TODAY() - Due2 > -3, "Yellow", "Green"))
Hope this helps.
Craig
