Valueexpression based on conditional statement | Community
Skip to main content
J
JordanMa
Level 4
May 7, 2019
Question

Valueexpression based on conditional statement

  • May 7, 2019
  • 2 replies
  • 600 views
Trying to figure out how to display certain data only if the field, "Current Go-Live At Risk" = Yes & the field, "Action Plan - If Applicable" is blank.. (Want it to display the red flag from conditional formatting, but again only if the one field = yes and the other is blank) I have tried many variations but am not having any luck. Valueexpression=IF({project:Action Plan - If Applicable}isblank,IF({project:Current Go-Live At Risk} = "Yes", "Missing")) Valueexpression=IF(ISBLANK({project:Action Plan - If Applicable}AND:1:({project:Current Go-Live At Risk} = "Yes", "Missing")) Also - Attempting to get the data as inline editable via this report, however the only one that is working, is a default field in Workfront and this one actually indicates, makeFieldEditable=false... When I add makeFieldEditable=true to any of my custom fields, nothing happens! Any ideas? Jordan Martinson LeaseTeam, Inc.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

P
PatriciaGr
Level 3
May 8, 2019
You can try "&&" as your AND ... And && Use this modifier to indicate that the condition is fulfilled when the expression finds an item that fulfills two conditions at the same time. For example, use the following statement in a calculated custom field to build an "IF" statement that finds projects that are in Current status and have a Condition of At Risk and marks them as "Mediation Needed." IF(Status="CUR"&&Condition="AR","Mediation Needed","") https://support.workfront.com/hc/en-us/articles/360018609394-Condition-Operators-in-Calculated-Custom-Expressions Patricia Greene JLL
E
EXP_-_DustinMa
Level 8
May 10, 2019
Hey Jordan, Once you convert from valuefield to valueexpression, you typically can't even force the field to become inline editable, as the calculation could be simple or complex, and the current iteration of Workfront's text mode system doesn't see the difference. Dustin Martin Assigned Support Engineer Workfront
Terms & ConditionsAccessibility statement

Loading footer...