Schedule Health based on End Date, Target End date and Todays date.


Need a formula for schedule health based on these conditions

Schedule Health- Red: When end date is greater than target end date and in case end date is blank, it should turn red if todays date is greater than target end date

Schedule Health - Yellow : In case end date is left blank and target end date is in next 4 days

Schedule Health - Green : When End date is less than target end date.


Feel free to share a different logic for the same problem statement.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!