Show only 1 Active Milestone in a project report | Community
Skip to main content
Level 2
August 20, 2026
Question

Show only 1 Active Milestone in a project report

  • August 20, 2026
  • 0 replies
  • 9 views

Hi,

I am currently showing a calculated field of Active Milestone(s) on a project report.  I have had a request to only show the first Milestone that is active if there are more than one.  Could someone help with the syntax for that?   My current syntax to show the active milestones is:

Edit=Text Modedisplayname=Active Milestone(s)listdelimiter=<div>listmethod=nested(tasks).liststype=iteratevalueexpression=IF({project}.{status}='CPL'&&{taskNumber}=1,"Complete",IF({canStart}&&{status}!='CPL'&&!ISBLANK({milestoneID}),{name}))valueformat=HTML

 

Thanks!

Heather