This isn't quite what I am looking for. I'm looking to isolate tasks/requests that were completed, filtered by whether the user was the approver. My assumption is that I should be able to filter by approval owner or something like that

My apologies, I totally forgot to get back to you on this! For us all users assigned to a task or request are expected to submit hours, and non of our reports seemed to support that. So we were looking for a report that would inform our users that they had missed submitting their hours when they wer...

This is what I'm looking for! I see it filtering in stuff the user has not reported hours on, which is great! And I spot checked to see those with hours were not owned by the user. Thank you so much, my manager has been wanting a report to do this for months. I knew what to do, just not how to do it

The task report is what I'm looking for, but I need to use an EXISTS filter to filter in tasks where there are no hours owned by the user, but I do not know how to get that EXISTS filter to work

Yes, I was just outlining my logical process. That is not the issue, the issue is using an EXISTS filter to isolate whether I the user have reported hours on a task/request

I would say that your CONCAT({plannedCompletionDate}) is unnecessary, you can just use {plannedCompletionDate}. For the color, you can't format just a single item on the list, it will always format every item on the list. If you are isolating a single task on the list, then you can create two separa...

I've used an expression like this with a collection column to Isolate a particular task from a list   valueexpression=IF(CONTAINS('First Word',{name})=true,IF(CONTAINS('Second Word',{name})=true,IF(CONTAINS('Third Word',{name})=true,CONCAT("Condensed Task Name - ",{plannedCompletionDate})," ")," "),...

I don't think this is possible. Using conditional formatting will always format everything within a column. To isolate elements you need to wrap elements in HTML using spacing columns. But when it comes to a collection, you cannot wrap individual elements because they can't be isolated

You won't be able to isolate the word "Delivered" with a list unfortunately, you would end up formatting the entire list. But if you did want to isolate a word, it would look something like this: column.1.valueexpression=IF(ISBLANK({actualCompletionDate})," ",{actualCompletionDate}) column.1.value=H...

Could you provide an example? Something I could copy and past and see what you mean. Thank you!