Milestone Data on Task Report

[AlisonW]

Good afternoon Workfront Community! I am in need of your wisdom today... I have a Task report to which I would like to add an icon indicator of whether the milestones on the Project were completed on time or not. The use case is a once monthly move to production of multiple system changes. One of the QC requirements is that lead times for user communication and other tasks are met. We have milestones for each of these steps. Has anyone ever done anything like this? If so, how? Also open to other strategies to achieve the end goal. Appreciate your thoughts and input on this little brain teaser! Thanks, Alison Alison Wells Community Medical Centers

[Doug_Den_Hoed__AtAppStore]

Hi Alison,

I'd suggest a calculated custom text parameter such as this:

IF(ISBLANK({milestoneID}),"not milestone",IF(ISBLANK({actualCompletionDate}),"not complete",IF({actualCompletionDate}> {plannedCompletionDate},"late milestone","milestone on time or early")))

And then hook an icon into it on your report (e.g. "late milestone" = sad face, "milestone on time or early" = happy face).

Regards,

Doug

[SuzyF]

Hello Doug,

I see you provided this reply many moons ago but I have the save use case.  I have a task report ready.  I need more detail on where to add the text above within the report.

Thanks for your time and solution,

Suzy

[Doug_Den_Hoed__AtAppStore]

Hi @SuzyF,

The formula I mentioned above would be placed on a calculated custom text parameter (e.g. Milestone Emoji) on a Task custom form and (then) attached to each such Task of interest, so that the report could then refer to it and display the appropriate icon (e.g. happy face, etc.)

Regards,

Doug

[Kundanism]

Hi @Doug_Den_Hoed__AtAppStore 

I tried to add this in calculated custom field for task custom form as,

IF(ISBLANK{milestoneID},"not milestone",IF(ISBLANK{actualCompletionDate},"not complete"),IF{actualCompletionDate}>{plannedCompletionDate},"late milestone","milestone on time or early")

But shows error as atatched here.

Any idea what is the cause?

Thanks in advance.

BR

Kundan.

[Doug_Den_Hoed__AtAppStore]

Hi @Kundanism,

The formula above was from 2017, so I've updated it to be compatible with the latest formula builder, and invite you to copy/paste try again at your convenience.

Regards,

Doug

[AlisonW]

Thanks Doug, I will give that a try. Looks like I may have to switch to a project report too. Alison Wells Community Medical Centers