How to write a formula with multiple conditions?

Options

Hi,

I have these 5 Phase columns in my project tracking sheet.

Now i want to automate the column named "Test" that shows at what phase the project is currently in.

The logic is something like: "If the Phase 1 is 100%, Phase 2 is 45%, Phase 3 is 65% then the project should be at Phase 2"

Ideally if the phase is at 100%, It should not take up that phase. If all the 5 phases are at 100%, It should show "Completed" and if all the phases are blank then "Not Yet Started"

Answers

  • Tomasz Giba
    Tomasz Giba ✭✭✭✭✭
    Options

    Hi @anzar

    Check if this works for you:

    =IF([Phase 5 Closing]@row = 1, "Completed", IF([Phase 4 Monitoring]@row = 1, "Phase 5", IF([Phase 3 Delivery]@row = 1, "Phase 4", IF([Phase 2 Development]@row = 1, "Phase 3", IF([Phase 1 Delivery]@row = 1, "Phase 2", "")))))

    Tomasz Giba

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!