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
I'm not really understanding the question, but you can do this, for example
IF(
IsNull([some date field]),"",
Today()>=ToDate([Date Complete]) and ToDate([Date Complete]) >= (ToDate([Projected Finish])), "<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\"; title=\"Inactive\">")
Quick Base processes the first test first and it is is true, it does not evaluate any further.
So you just line up your tests sequentially
IF(
this is true, result 1,
that is true, result 2,
something else is true, result 3)
IF(
IsNull([some date field]),"",
Today()>=ToDate([Date Complete]) and ToDate([Date Complete]) >= (ToDate([Projected Finish])), "<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\"; title=\"Inactive\">")
Quick Base processes the first test first and it is is true, it does not evaluate any further.
So you just line up your tests sequentially
IF(
this is true, result 1,
that is true, result 2,
something else is true, result 3)