IF THEN formulas for status balls

natalie.fitzpatrick100276

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))

 

 

Paul Newcome

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.................................