IF THEN formulas for status balls
I am trying to use an IF THEN formula to show status balls. I have a "due date" column and a completion column. If the date in the completion column is more than 7 days later than the date in the due date column, I'd like the status ball to be red. If the date in the completion column is within 7 days of or before the date in the due date column, I would the status ball to be green. Below is the formula I have tried without success.
=IF(([Laundry Completion Date]:[Laundry Completion Date]) > ([Start Date]:[Start Date]); "red"; IF(([Start Date]:[Start Date]) > 7; "green"; IF([Start Date]:[Start Date) < 7))
Comments
-
Instead of referencing the entire column in your formula, you should be referencing specific cells (and you don't need the extra set of () around the cell references either).
=IF(([Laundry Completion Date]:[Laundry Completion Date]) > ([Start Date]:[Start Date]).................................
should be
=IF([Laundry Completion Date]@row > [Start Date]@row.................................
