Expand my Community achievements bar.

JasonMu
JasonMu
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • Hi Brandon, I think you are looking for a nested if statement valueexpression=IF({project}.{DE:Final Files Due Date}>=0,IF({plannedCompletionDate}>={project}.{DE:Tactic Requested Due Date},"Needs Attention","On Time"),IF({plannedCompletionDate}>{project}.{DE:Final Files Due Date},"Needs Attention","...

    Type

    Questions

    Views

    1.0K

    Likes

    0

    Replies

    0
  • Hi Skye, Thank you, That is exactly what I was missing. No need to fail around. :) It even worked on the value expression column, this is a double win! To help others, I added. The Bolded line to make the styling work - styledef.case.0.comparison.leftmethod=project.plannedCompletionDate styledef.cas...

    Type

    Questions

    Views

    663

    Likes

    0

    Replies

    0
  • Hi Skye, Thank you for the response, I will look into whether I can add an additional field for this. I did try an run this on a normal column and had the same result, Is it possible to do a comparison of two fields for formatting purposes or does it have to be a static Date Example: styledef.case.0...

    Type

    Questions

    Views

    663

    Likes

    0

    Replies

    0
  • Hi, This seemed to be straight forward but ended up not being so. I built a custom column and the formula to get the results works fine. When I try and build in some formatting nothing seems to work. I am calling on real fields from the system and not relying on anything created so the formatting lo...

    Type

    Questions

    Views

    663

    Likes

    0

    Replies

    5
Top badges earned by JasonMu
Customize the badges you want to showcase on your profile