If formula with multiple conditions


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 :(



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!