Calculated field that displays a task Planned Start Date, but will Display an Actual Start Date if present

[SethPo1]

Hi All,

I wanted to know if it is possible to create a calculated field that uses IF logic to diplay a task's Planned Start Date, but will then display a task's Actual Start Date if present?  I currently have a calculated field that displays Planned Start Date - Planned Completion Date in one column for reporting, but I want to see if it possible to level it up.

[Richard_Le_ · Accepted solution]

Hi Seth,

This is possible to do with the following expression:

IF(ISBLANK({actualStartDate}),{plannedStartDate},{actualStartDate})

Or in a column on a report, you'd use the following:

displayname=Start
textmode=true
valueexpression=IF(ISBLANK({actualStartDate}),{plannedStartDate},{actualStartDate})
valueformat=HTML

Best Regards

Rich

[SethPo1]

Thanks Richard!  Your calculation was my missing link.