Expand my Community achievements bar.

KathyLe1
KathyLe1
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • 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...

    Type

    Questions

    Views

    784

    Likes

    0

    Replies

    0
  • 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 ...

    Type

    Questions

    Views

    292

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    968

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    968

    Likes

    0

    Replies

    0
  • 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)

    Type

    Questions

    Views

    729

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    844

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    844

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    844

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    844

    Likes

    0

    Replies

    0
  • 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 ...

    Type

    Questions

    Views

    844

    Likes

    0

    Replies

    9
Top badges earned by KathyLe1
Customize the badges you want to showcase on your profile