formula for status column using symbols based on end and target dates
I would like the status column (set to red and green, ball symbols) to automatically update based on task due today vs target date. Here is what I would like:
If end date is not past target date then status is green
If end date is past target date then status is red
Could someone help with the formula?
Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!