Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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.