


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.
Views
Replies
Sign in to like this content
Total Likes
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
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
Thanks Richard! Your calculation was my missing link.
Views
Replies
Sign in to like this content
Total Likes