NEED HELP: Health Formula based on start date, end date, and %100 complete needed.
I'm really struggling with a smartsheet formula.
This is what I'm attempting:
=IF([Plan Start]@row > TODAY(), "Green", IF([Plan Start]@row < TODAY(), "Yellow", IF([Due Date]@row >[Due Date]@row TODAY(), "Red") OR(IF([% Complete]@row = "1", "Blue")))
Essentially I'm trying to make a formula that says: If It's before start day = blank, if start date or after = green, if 1 week before due date = yellow, if due date or after = red, if % Complete column is 100% = blue
Any help is appreciated
Help Article Resources
Check out the Formula Handbook template!