icon formula for date
Need a formula to generate an icon in the following instances Green circle icon displayed when [Due date] has not yet been met (as of today) Yellow circle icon displayed when [Due Date] is today o...
Forum Discussion
The formula would be something like this. But I have not tested it. I suggest getting it working to calculate the result in words first to be sure it's working.
IF(
Today() > [Due Date], "red",
WeekdaySub([Due Date],Today())<=1, "yellow", "green")
IF(
Today() > [Due Date], "red",
WeekdaySub([Due Date],Today())<=1, "yellow", "green")