Valueexpression based on conditional statement

[JordanMa]

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.

[PatriciaGr]

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-Custo... Patricia Greene JLL

[EXP_-_DustinMa]

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