Reporting on which Milestone a project is currently in | Community
Skip to main content
T
TraceyMa
February 15, 2018
Question

Reporting on which Milestone a project is currently in

  • February 15, 2018
  • 12 replies
  • 2626 views
Hello Community, I would like to be able to report on which Milestone a project/task is currently in. Anyone know how to get this on a report? I noticed that one of the Status Icons shows the current Milestone and feel that's maybe a clue some how. Gratefully, Tracey Mathews
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

12 replies

Show previous replies
T
TraceyMaAuthor
February 27, 2018

Thanks Melinda and tell Marty I said HI! Thank you to everyone who contributed.

For fun I tried both and there were small differences. However, I think it would be a big difference if the phrases in the list were shorter. My milestone have multiple words. Here is a side by side of the 2 methods. &zwj; vs. <p>.

J
JaneSt1
Level 2
October 4, 2019

Hi Narayan!

Going a bit back in time here...but can I use this text method on a Request-based report? Maybe there is something wrong with ability to use listmethod across objects?

displayname=Active Milestone

listdelimiter=&zwj;

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=TRIM(IF(ISBLANK({resolveProject}.{milestoneID})=0,IF(ISBLANK({actualCompletionDate}),IF({canStart}=1,CONCAT({resolveProject}.{milestone}.{name},"; "),""))))

valueformat=HTML

ChristinaJay
ChristinaJay
Level 4
October 23, 2023

Revising an old thread - anyone ever figure this out?

 

Possibly create a calculated field on a task form, that displays what milestone the current task is a part of. 

 

I'm trying to create this in fusion, so far. 

Terms & ConditionsAccessibility statement

Loading footer...