Hello everyone, I'm working on a textmode script that will display the last milestone hit. script below: valueexpression=IF(!ISBLANK({milestoneID})&&DAY({actualCompletionDate})<=$$TODAY&&{milestone}.{name}="3. Creative Complete",{milestone}.{name},IF(!ISBLANK({milestoneID})&&DAY({actualCompletionDate})<=$$TODAY&&{milestone}.{name}="5. Go Live",{milestone}.{name},""))
listdelimiter=
listmethod=nested(tasks).lists
valueformat=HTML
displayname=Last Milestone Hit
textmode=true
type=iterate
Currently, if both of the milestones are completed then the column will display both milestones.
What I'm trying to achieve is to replace the value if the next milestone is met. For example:
Check the first milestone, update the column value if it's completed. Check the next milestone, replace the current column value with this milestone if it is also met.
Currently, if both milestones are met, the output looks like this: 3. Creative Complete 5. Go Live desired output when both milestones are met would be: 5. Go Live
I've been looking for text mode documentation, but can't find anything to replace the value of the column. is there something like "CONCAT()" that I'm missing? Any other ideas? Thanks! Parker Cantu MultiView