Hi community! Trying to show a specific milestone duration (in days) in a collections report. My current text mode below just returns minutes, and I know the valueformat needs to be updated to something similar to valueformat=compound#M:D but I'm not sure where to do it in the value expression. Addi...

So helpful - thank you so much!

Thanks, Nichole! This helped, but I'm realizing there are multiple sub parent tasks with strategy in the name, so it's pulling those in too. Open to any suggestions (even if it's a task report) to pull this in a little cleaner. I'm just struggling to isolate the parent task. We have a lot of tasks t...

I'm using this text mode to see the actual completion date of the Strategy task, but the task is a parent task and it's not pulling in. Is there a different label to pull in parent tasks?  displayname=Strategy Complistdelimiter=<p>listmethod=nested(tasks).liststextmode=truetype=iteratevalueexpressio...

The only challenge would then they wouldn't be able to use the typical 'mark done' feature and would always need to change the status, so a bit of a learning curve but not off the table. thank you!

Interesting idea, but the creatives more heavily rely on accurate due dates so the approval loop would probably throw them off a bit. Thank you, though!

Is there a way to create an 'approved with changes' in Workfront approvals so that the approval doesn't get triggered again the second time someone completes the task? We're not using the proof workflows. Ex: Creative marks done on the task --> task status complete - pending approvalDirector rejects...

Hi Anthony! This is such helpful syntax! I was wondering if you could see where I'm going wrong with this - on a project report, I'm trying to filter out any projects where the milestone name AUDITS RECEIVED doesn't exist. Is that possible? I'm wondering if the obj code needs to be MILESTONEPATH?EXI...

Thank you!

I got it to work with this: valueexpression=IF({milestone}.{name}="AUDITS RECEIVED",IF(AND({status}="DED","N/A", {plannedCompletionDate}<$$TODAY), " ",IF(AND({status}="DED","N/A", {plannedCompletionDate}>$$TODAY), " ",IF(CONTAINS("CPL",{status}), CONCAT("Completed ",{actualCompletionDate}),IF({plan...