If formula with multiple conditions

Justyna Wlodarz

Hi Smartsheet Heroes :)

I need o create function using this conditions and symbols (Green, Amber, Red) based on numeric column with Delay...

Condition 1: IF Delay less then 1 week then GREEN

Condition 2: IF Delay between more then 1 week and less then 4 weeks then AMBER

Condition 3: IF Delay more then 4 weeks then RED.

Do you know how the syntax should be created? I tried to create in million times and still doesn't work :(

Cheers,

Justyna

Andrée Starå

Hi Justyna,

If I understand you correctly something like this should work.

=IF(OR(ISBLANK(Start@row); ISBLANK(End@row)); ""; IF(End@row - Start@row > 28; "Red"; IF(End@row - Start@row < 7; "Green"; IF(End@row - Start@row < 28; "Yellow"))))

The same version but with the below changes for convenience.

=IF(OR(ISBLANK(Start@row), ISBLANK(End@row)), "", IF(End@row - Start@row > 28, "Red", IF(End@row - Start@row < 7, "Green", IF(End@row - Start@row < 28, "Yellow"))))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Justyna,

If I understand you correctly something like this should work.

=IF(OR(ISBLANK(Start@row); ISBLANK(End@row)); ""; IF(End@row - Start@row > 28; "Red"; IF(End@row - Start@row < 7; "Green"; IF(End@row - Start@row < 28; "Yellow"))))

The same version but with the below changes for convenience.

=IF(OR(ISBLANK(Start@row), ISBLANK(End@row)), "", IF(End@row - Start@row > 28, "Red", IF(End@row - Start@row < 7, "Green", IF(End@row - Start@row < 28, "Yellow"))))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Justyna Wlodarz

It works! :)

Thank you so much Andree :)

Andrée Starå

Excellent!

Happy to help!