Expand my Community achievements bar.

SOLVED

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

Avatar

Level 4

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.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Level 4

Thanks Richard!  Your calculation was my missing link.