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.
Solved! Go to Solution.
Views
Replies
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
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies