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

Options

Answers

  • Dereshnie
    Options

    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
    DKazatsky ✭✭✭
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!