How do I create a formula in a symbol column that assigns a RAG status based on duration?

Dereshnie

Dereshnie

I've tried this... but it doesn't seem to work:

=IF([Current Time to Fill in weeks]@row < 6, "Green", IF([Current Time to Fill in weeks]@row > 6, "Yellow", IF([Current Time to Fill in weeks]@row > 10, "Red"))).

DKazatsky

Hi @Dereshnie

Try this: =IF([Current Time to Fill in weeks]@row < 6, "Green", IF(AND([Current Time to Fill in weeks]@row > 5, [Current Time to Fill in weeks]@row < 10), "Yellow", "Red"))

This assumes "Yellow" includes 6 and "Red" includes 10.

Hope this helps,

Dave