Calculated field that displays a task Planned Start Date, but will Display an Actual Start Date if present | Community
Skip to main content
P
Pat_Paterson
New Participant
March 13, 2023
Solved

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

  • March 13, 2023
  • 1 reply
  • 661 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

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

1 reply

R
Richard_Le_Accepted solution
New Participant
March 13, 2023

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

    P
    Pat_PatersonAuthor
    New Participant
    March 14, 2023

    Thanks Richard!  Your calculation was my missing link.

    Terms & ConditionsAccessibility statement

    Loading footer...