Caseを使うんだ。勉強になった。
AND(
TEXT( Status ) = "Closed",
OR(
ISBLANK(TEXT( Picklist_A )),
AND(
CASE( Picklist_A ,
"Option-A",1,
"Option-B",1,
"Option-C",1,
0 ) = 1,
ISBLANK(TEXT( Picklist_B )),
)
)
)
More than 1 year has passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme