RYG Health formula based on due date and % complete

Archie

I'm trying to create a formula to calculate the below:

'Due date' is in the next 10 days and '% complete' is less than 50% = "Red"

'Due date' is in the next 10 days and '% complete' is less than 90% = "Yellow"

'Due date' is in the next 10 days and '% complete' is greater than 90% or 100% = "Green"

Paul Newcome

This should do it for you:

=IF([Due Date]@row<= TODAY(10), IF([% Complete]@row<= 0.50, "Red", IF([% Complete]@row<= 0.90, "Yellow", "Green")), "Green")

Paul Newcome

Try this:

=IF([Due Date]@row<= TODAY(10), IF([% Complete]@row<= 0.50, "Red", IF([% Complete]@row<= 0.90, "Yellow", "Green")))

Archie

Thanks Paul, yes thats done it but can it be made to show "Green" if the due date is more than 10 days away?

Paul Newcome

This should do it for you:

=IF([Due Date]@row<= TODAY(10), IF([% Complete]@row<= 0.50, "Red", IF([% Complete]@row<= 0.90, "Yellow", "Green")), "Green")

Archie

thanks, thats ideal

Paul Newcome

Happy to help. 👍️