Task Status Formula help

Marieinsd ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to update the below status formula to update the "yellow" status to be determined by a % complete less than 25% and the Due Date (week of) is between 7 and 14 days in the future.  

Here is the current formula:

=IF([% Complete]26 = 1, "Green", IF(AND([% Complete]26 <= 0.25, [Due Date (week of)]26 > TODAY()), "Yellow", IF(AND([% Complete]26 >= 0.26, [% Complete]26 <= 0.99, [Due Date (week of)]26 > TODAY()), "Blue", IF(AND([Due Date (week of)]26 <= TODAY(), [% Complete]26 < 1), "Red", ""))))

Here is a formula I have been working with to satifsfy second part of the "yellow" status:

=IF(AND(([Due Date (week of)]32 - TODAY()) > 7, ([Due Date (week of)]32 - TODAY()) < 14), "Yellow")


How do I integrate the second formula into the first one and get it work?





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!