Adding Item Status to the Completion Status Formula

Platform discussions
,
1

Hello,
I am trying to include additional items status to the Completion Status Formula. I would like to Done On Time checkmark shows up with other status, besides “Done”.
Thank you very much for your help.

This is the current formula: IF({Status}=“Done”,IF(DAYS({Timeline#End},{Completion Date})<0,“Done Late :ballot_box_with_check:”,“Done On Time :white_check_mark:”),“”)

image
image1500×515 82.7 KB

2

Hi Beatriz,

This format should work for you. You can add commas to the OR function as far as I recall (and if not, you can safely nest OR statements). This should allow you to add more statuses, as you can see in my example.

IF(
    OR(
        {Status}="Done",
        {Status}="Example Status"
    )
    IF(
        DAYS(
            {Timeline#End},
            {Completion Date}
        )<0,
        "Done Late :ballot_box_with_check:",
        "Done On Time :white_check_mark:"
    ),
    ""
)
3

Thank you so much, Francis, this formula worked perfectly!
Have a great day!

1 Like