How to add one more condition of OR in valueexpression of when using IF(ISBLANK.....)

Forum|Forum|2 years ago
December 11, 2023
2 replies
1283 views

Hello All, in text mode, I would like to add one more condition of OR relation into expression, see my valueexpression below, if my expression wrong, if someone can point me on this? thanks!

Textmode=true

displayname=Overall Status

IF(ISBLANK({DE:Confirm receipt QTY}) or ISBLANK({DE:Confirm receipt date}),"OPEN","CLOSE")

valueformat=HTML

When I used one condition (without OR), it is OK, so I guess my OR expression is wrong, need your help here! thanks!

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Dougplganger

#aacgotcha01

DougplgangerAccepted solution

Level 2

#aacgotcha01

J

JerryWuAuthor

Level 2

Thanks Dougplganger! another question, if I wanted to make this column result of "OPEN" and "CLOSE" as grouping, How can I do that by text mode?

Below is what i made the grouping before by queueTopic:-

group.0.linkedname=convertedOpTask
group.0.namekey=Queue Topic Name
group.0.valuefield=convertedOpTask:queueTopic:name
group.0.valueformat=HTML
textmode=true