Changing status symbols if a task is not completed before due date


I recently found someone with a similar issue after doing a search in the Community and hoped it would help me but I haven't been able to succeed even though it got me close.

Forum for reference:

I need to do the following:

  • If project has not started = "Grey"
  • If project is in progress (percentage is increasing 1%-99% to show in progress) = Green
  • If project reaches 100% at or before end date = "Green"
  • If project is at 75% or below and we're 2 days away from the end date, project is not complete = "Yellow"
  • If project/task is at end date and the percentage complete is not at 100% = "Red" (I guess based on the bullet above, 76% and up = "Red")

Like the person who had the same issue above, I have "Start Date", "End Date", "% Complete" columns.

I hope this is clear. Let me know if you have any questions.




Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!