IF formula and dates: 'Red' status if the % complete is not 100% and the date is in the past

Harriet Blackborow

Hi there,

Is it possible to incorporate dates in an IF formula? Essentially I want the RAG status to automatically go to 'Red' if the %complete is not 100% and the date is in the past - how would I go about doing this?

Thank you

Vivienne Strettle

Hi Harriet. Yes it is. In a column called 'At Risk' I put =IF(AND([% Complete]3 < 90, [Delivery Date]3 <= (TODAY() + 3)), "Red", "Green").

Viv

Harriet Blackborow

Hi Viv,

Thank you so much for your help, I'll give this a go.

Harriet