Symbol formula question

Hello! I'm looking for a formula which has the following rules...

There is a sheet with a due date column, a date begun column, a % complete column (manual entry), and an Urgency column which will be the symbols with the formula.

If you are past the due date and the task is not 100% complete, red

If you are between the start date and the due date, check todays date against the % of task you've completed. If you are ahead of the task, green, otherwise, yellow.

So for example if there are 10 days between the date began and the due date, and today's date falls is on day 5, the task should be 50% complete or higher to be green, but if its lower, yellow.

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!