OK- now I have a new scenario where colored indicator dots (as we were shown in previous workshops) may be useful.
Upon creation of a new project on the list, the workflow action "add time to date" creates variable called "warning date" which = three days before the due date. Those three days would constitute a sort of "warning period." (I am not sure how to allow for this.)
NEEDED: formula for a color-dot indicator that does the following:
1) If status = In Progress and current date is less than warning date, show GREEN dot
2) If status = In Progress and current date is during the "warning period," show YELLOW dot
3) If status = In Progress and current date is equal to or greater than Due Date, show RED dot.
4) If status = Completed, show no color.
