Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
I tried to add this in calculated custom field for task custom form as,
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Views
Replies
Total Likes