I figured it out! This will pull in the milestone planned completion date if it's not complete and do a green dot if it's not overdue and a red dot if it is. If it's complete, it'll pull in Completed and then the actual completion date! valueexpression=IF({milestone}.{name}="AUDITS RECEIVED",IF(AND(...

I'm not actually using any calculated fields ... but now I might look into it to help me out in the future!

The second one is ALMOST there, but I can't get the actual completion date to pull in with 'complete'. The bold is what I added, but then it just pulls in the {actualCompletionDate} and not the date itself. valueexpression=IF({milestone}.{name}="STRATEGY APPROVED",IF(CONTAINS("DED",{status}),"N/A",I...

In a project collections report, I'm trying to work through this text mode to show:If milestone = Complete, CONCAT "Completed, actualCompletionDate" (that part is working)If milestone isn't complete, CONCAT "Due, plannedCompletionDate" and if the planned completion date is past $$TODAY, include [RED...

This value expression is successfully showing the milestones that are complete or that are not complete but not overdue: valueexpression=IF({milestone}.{name}="STRATEGY APPROVED",IF(AND({status}="DED", {plannedCompletionDate}<$$TODAY), " N/A",IF(AND({status}="DED", {plannedCompletionDate}>$$TODAY), ...

This is SO amazing. I was wondering if you could help me work out using the value text to pull in a specific milestone? Right now I'm pulling in the 'AUDITS RECEIVED' milestone into this column and noting if it's due or completed. If it's still due, how do I add this if statement to then put the red...

This is very helpful! Is there a way to filter out parent tasks?

Thank you SO much!!

This is honestly amazing and my company could totally benefit - is it too much to ask for all of the text modes please? Happy to chat over email as well if that's easier. I feel like I'd spin my wheels for days trying to recreate. Thank you!

This whole report seems amazing and I'm wondering if you'd share its use case and the type of text mode you're using for the columns? Is it a collection report for a project? I'm looking for something similar... Thank you!