Still coming up blank. Could it be that this field is from a check box and the user is allowed to check more than one option? Maybe the conditional is looking for the entire result to match one of the options? But if there are more than one checked it throws it off?

Thanks @Anthony Imgrund‚ . I always forget about the spaces, I typically add them in out of habit and for legibility's sake. I put those "null" strings in as placeholders. I'll need to add a bunch more conditionals to cover all the options coming into this field. I'm guessing there isn't a better wa...

I need to shorten the value of a field to the Value Field instead of the Label. I'm trying to get this conditional to work but it seems to be failing. Is there a better way to do a string replace?valueexpression=IF({project}.{DE:Deliverable Aspect Ratio} = 'HD - 16:9 - 1920 x 1080', 'HD', IF({projec...

I got it to work. I had several OR statements and needed to add these lines to each one. Byron Nash INSP, LLC.

Thank you. These discussion forums are a nightmare to search! I should have seen that post but I didn't and I tried searching. Byron Nash INSP, LLC.

So Jessie, if you add that to the filter text mode string it should filter down to just Projects in Current status? I added it but I'm not seeing any results. Could it be conflicting with my grouping by project status? Byron Nash INSP, LLC.

You may find this community thread helpful: "https://one.workfront.com/s/question/0D50z00006Px3HTCAZ/" Filtering Out Projects Based on Status on Proof Approval Report Terry Hynd EBSCO Information Services

Thanks for the replies @Doug Den Hoed - AtAppStore and @Matt Thomas . I do agree that you can do some powerful things with Text mode, I just find it difficult compared to other scripting level tasks I've tried in other platfoms. I'll reach out on your link Matt, thanks. Byron Nash INSP, LLC.

Is there really no better way to display the label in a calculation than manually decoding it? I have some dropdown fields on shared reports that are constantly in flux. It would be time prohibitive to have to go edit the textmode conditionals every time they update the lists. I'm highly disappointe...

I'm having a similar issue, but I'd like to specify column widths for more than one column. I have the "widths" line in most of my columns. It's not really behaving though. It's also repeating it across my team so I don't imagine it's the cache. Any other ideas? Very nice column trick Patricia. Byro...