Help with RYGB Formula for Days past Start Date, Blue = Complete Status from Multi Select
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
Complete (Activation complete)