Just because I am a glutton for punishment curious, I tried to make the EXIST filters that Doug alluded to. I think I have it down, but just be warned, the report was taking a while to load. I'm not super confident in building EXIST filters, so there's a good chance that this is clunkier than it nee...

We recently rolled out a survey to our users and had about a 19% response rate. I posted about it in the community a few weeks ago and provided screenshots of the questions that we asked our team members:https://one.workfront.com/s/question/0D54X000073pyZUSAY/has-anyone-conducted-internal-surveys-to...

Yup, that's possible. For example, f the task will contain the text "Oversight Task", then you can just add that into the existing formula CONTAINS("Oversight Task",{name}). If you need a separate keyword, I'd recommend building it as an "OR" (in a valueexpression, you can build an "OR" statement w...

Hi Laura! This valueexpression should work to exclude tasks with the name "Oversight": valueexpression=IF(CONTAINS("Oversight",{name}),"",IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," ")))) ----------- I did just want to mention - the code you provided (and th...

You could consider adding the filter for Project Users >> User ID equals $$USER.ID. The only caveat is that if they're assigned to Task D, but not A, B, or C, that project will still show up on their report because they're technically users on the project, just not on the specific tasks you're looki...

Lyndsy - are you looking for something that just counts the # of options that were selected? If so, you could use this: IF(ISBLANK(Field Name),"0",LEN(Field Name)-LEN(REPLACE(STRING(Field Name),", ","x"))+1) Just a heads up - this formula wouldn't work if your checkbox options contain a comma. I hav...

Hi Tony! Default views can be set through the layout templates. Here's how to do it: -----------------------Go to Setup >> Interface >> Layout Templates Open the layout template that you want to adjustClick on the dropdown for "Customize what users see" >> Select "Lists"On the right, click on the dr...

Hi all! I came across this post last week because I was looking for the same solution that Nick was. I think I just figured out how to use a task report but filter out anything that the specific user had already marked as "Done with My Part". I took my existing task report filters, then added a chun...

Honestly, I always have the hardest time with "AND:1" filters when I have a "OR" filters in the report. It always disregards the "OR" filters that I build or it does some weird combination of the filters.. I don't know if it's user error or what, but I eventually gave up trying. That said, I think ...

Anthony/Doug, funny enough we actually had that exact use case for our designers at one point. Megan - this was the value expression we used, which is identical to Anthony's formula + Doug's suggestion, except instead of nesting in another IF statement, we added in an "and" condition (syntax is jus...