Task Condition html for Date Completed
In Project Manager, I'm using HTML to link the Task Condition buttons to Start and End Dates, as opposed to the manually updated "status" menu. This way, the "inactive" button will appear automatical...
Forum Discussion
Works great thank you. Here it is.
If (Today()>=ToDate([Date Complete]), "<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\"; title=\"Inactive\">",
If (IsNull(ToDate([Date Complete])) and (ToDate([Start])>(Today())), "<img src=\"https://images.quickbase.com/si/16/049-clock.png\"; title=\"Delayed Start\">",
If (IsNull(ToDate([Date Complete])) and (Today()=ToDate([Start]) and (Today()<=ToDate([Projected Finish]))), "<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"; title=\"On Time\">",
If (Today()>ToDate([Projected Finish]) and (IsNull(ToDate([Date Complete]))), "<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"; title=\"Overdue\">",
If ([Status]="Issue", "<img src=\"https://images.quickbase.com/si/16/223-point_yellow.png\"; title=\"Issue\">"
)))))
If (Today()>=ToDate([Date Complete]), "<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\"; title=\"Inactive\">",
If (IsNull(ToDate([Date Complete])) and (ToDate([Start])>(Today())), "<img src=\"https://images.quickbase.com/si/16/049-clock.png\"; title=\"Delayed Start\">",
If (IsNull(ToDate([Date Complete])) and (Today()=ToDate([Start]) and (Today()<=ToDate([Projected Finish]))), "<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"; title=\"On Time\">",
If (Today()>ToDate([Projected Finish]) and (IsNull(ToDate([Date Complete]))), "<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"; title=\"Overdue\">",
If ([Status]="Issue", "<img src=\"https://images.quickbase.com/si/16/223-point_yellow.png\"; title=\"Issue\">"
)))))