Hello Smartsheets Friends,
Using a Smartsheet for keeping track of Activation Status. Here is what I am hoping to achieve.
1-7 Days from Handover Date = Activation Call Status - Green
8-14 Days from Handover Date = Activation Call Status - Yellow
15+ Days from Handover Date = Activation Call Status - Red
When customer Status is selected (from Multi Select options below, currently 5th from top) Complete - Blue
A bonus would be incorporating workdays as the only days to be counted. I've tried several iterations of formulas but I keep getting unparseable. Like many early friends on Smartsheets, I have not worked with formulas at all and work in a customer-facing role. I am creating this in order to better help my team be more organized. I would greatly appreciate it if someone can recommend the best formula to use and would also appreciate the time given. Thank you, friends.
Multi Select Options order
Unresponsive
Stalled
Pending Response
In Progress
Complete (Activation complete)
N/A
