Hi Ondina, If I understand what you’re looking for, you want to take the following text: http://www.workfront.com/level1/level2/doc.aspx And return: level1/level2/doc.aspx Is this correct? If so, you might try this instead: RIGHT({field},LEN({field})-(SEARCH(".com/",{field})+5)) The tric...

Hi Tammy, You’ll need to enter text mode and add the following text: usewidths=true width=150 You’ll have to play with the width number until you get something that works for you. If you then need to adjust any of the other column widths, just add the “width=###” line to ...

Sarah, specifically in regard to your question, the following works for a popup displaying the last note: displayname=Task Note image.case.0.comparison.icon=true image.case.0.comparison.leftmethod=lastNote:noteText image.case.0.comparison.lefttext=lastNote:noteText image.case.0.comparison.operator...

Hi everyone, If I'm understanding the requirement properly, I believe this approach will work (at least it seems to for me). I came at it a little differently. I just added the "description" field and then used conditional formatting to display an icon (if not blank). I then played around a bit wi...

Just for the heck of it, you might try adding some parentheses to it to clarify the order of operations. It might be getting confused by trying to do too much at once. So, something like: ROUND((Actual Hours/60)/7.5,1)

While this doesn’t solve the original issue I posted, I figured I would share a strategy that seems to work for date field to date field comparisons. You may know that when you are setting up a conditional formatting rule, that you can sometimes type FIELD: in the right side of the rule, s...

Thanks, Narayan. Yes, that's exactly it, although there are times when it's not even dates I'm dealing with; it may be strings. I've tried a bunch of different combinations of things in text mode, but I can't seem to get anything to work. It just seems very limiting to have to add more fields any ti...

Hi Doug, I’ve gotten conditional formatting to work as well, just never when what I’m comparing against is the outcome of an expression. Since I can’t see what’s going on in the background of your example, were you using an expression (as opposed to a field) as the basis fo...

Thanks, Eric. Yes, the custom field option is the only thing I've found so far as well. If that was what remote consulting came up with for you, then I'm thinking it's unlikely there is another solution. I'm still hopeful, though, that maybe someone has found a way to trick the system....or that...

Does anyone know if there is a way to achieve expression based conditional formatting? The only way I'm aware of to get there is to add the expression as a custom field and create the condition based off the custom field. However, the ability to do this on the fly within the report (without the use ...