Hi folks, seeing if anyone has a way to do this...
I have a task report pulling values from a task custom form on all projects via templates that indicates if the project met or didn't meet the SLA (based on the task custom form looking at when a certain set of tasks in the project was completed vs the SLA). I have this working fine, and reports with bar charts show projects that didn't vs. did meet the SLA. What I'm after is if any the projects ever when to On Hold status any point in the project. I want to add this as a report column and not a filter since I don't want to filter them out, but just to give context in a column to show for example XYZ projects that didn't meet the SLA, the column can show me if it ever went On Hold (not tasks, the project itself). Is this possible in a text mode value expression in a column? I tried messing with cicontains=On Hold and project:noteText but not getting anywhere.
If this helped you, please mark correct to help others : )