Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit is happening now. Discover what's next in customer experience.
SOLVED

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

Avatar

Level 3

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

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 3

Thanks Richard!  Your calculation was my missing link.