Question
Show only 1 Active Milestone in a project report
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