I'm trying to create a bot where if certain key phrases are selected from a dropdown in my RESULTS column, another column is marked as DONE. I figured out the second (DONE) part of the bot. The problem is I have 7 RESULTS columns. So I need DONE to be marked if the phrase is in any of those columns. Is there a way to include them all in the same bot as opposed to making 7 bots for each one?
This is my expression for one column which works great:
IN([RESULTS 1],
LIST(
"no contact info available", "No contact info available",
"no contact info available.", "No contact info available",
"house does not exist", "House does not exist",
"vacant", "VACANT", "Vacant"
)
)
I tried something like this, but it didn't work. I'd appreciate any help. Thanks in advance!
IN([RESULTS 1],[RESULTS 2],[RESULTS3],
LIST(
"no contact info available", "No contact info available",
"no contact info available.", "No contact info available",
"house does not exist", "House does not exist",
"vacant", "VACANT", "Vacant"
)
)
Solved! Go to Solution.
How about
ISNOTBLANK(
INTERSECT(
LIST([RESULTS 1], ... [Results 7]),
LIST( "nocontact..",...)
)
)
?
How about
ISNOTBLANK(
INTERSECT(
LIST([RESULTS 1], ... [Results 7]),
LIST( "nocontact..",...)
)
)
?
Awesome!! Yes, this expression worked very well and made it much simpler. Thank you!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |