RYB Automation Question

Manuel Lemus
Manuel Lemus ✭✭✭✭


I am looking for some assistance with automating the RYG Status Balls in my Sheet. Below is my data, and I am attempting to key off the "smartxpo launch date". What I want to do is assign a Red, Green, or Yellow status ball with the conditions below. IF the SmartXpo Launch Date is between 100-90 days, then assign a green ball. If the date is between 90-10 days then assign yellow ball. If the date is between 10-0 days, then assign a red ball. Note I added a column to calculate the days out, but I cannot figure out how to add the formula.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!