Can I include several columns in one bot?

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 Solved
0 2 68
1 ACCEPTED SOLUTION

How about 

ISNOTBLANK(
 INTERSECT(
  LIST([RESULTS 1], ... [Results 7]),
  LIST( "nocontact..",...)
 )
)

View solution in original post

2 REPLIES 2

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!

Top Labels in this Space