Hmmm maybe try..... valueexpression=IF({milestone}.{name}="AUDITS RECEIVED",IF(CONTAINS("DED",{status}),"N/A",IF({plannedCompletionDate}<$$TODAY,CONCAT("",{plannedCompletionDate}),CONCAT(" ",{plannedCompletionDate})))) Or if you wanted it to say something different when complete, try... valueexpres...