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 :(
Help Article Resources
Check out the Formula Handbook template!