Nested IF and percents

Answers

  • IPC
    IPC ✭✭✭

    Hello @Paul Newcome,


    Can you help me with the syntax as well please?

    =IF([% Complete 2023-Q1]@row =0, "Not Started"),

    IF(AND([% Complete 2023-Q1]@row > 0 and <= 0.25, "Initial Progress"),

    IF(AND([% Complete 2023-Q1]@row > .25 and <= 0.50, "Mid-way Progress"),

    IF(AND([% Complete 2023-Q1]@row > .51 and <= 0.90 "Major Progress"),

    IF([% Complete 2023-Q1]@row =1, "Completed")))))

    Basically if progress is 0 then not stargted

    1-25% = Initial progress

    26-50-mid-way progress

    51-90 Major progress

    Above formula results to unparseable

    Thanks in advance.

    IPC

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @IPC,

    This formula should do what you're after:

    =IF([% Complete 2023-Q1]@row = 0, "Not Started", IF([% Complete 2023-Q1]@row <= 0.25, "Initial Progress", IF([% Complete 2023-Q1]@row <= 0.5, "Mid-way progress", IF([% Complete 2023-Q1]@row <= 0.9, "Major Progress", IF([% Complete 2023-Q1]@row = 1, "Completed")))))

    Output:

    There is small gap where nothing is returned between 90 and 100%, but other than that it fulfils your requirements.

    If you've any additional questions or comments then just post! 😊

  • IPC
    IPC ✭✭✭

    Thanks @Nick Korna. The missing part is "under approval".

    It works. thanks a lot.

    IPC

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!