Hello, apologies in advance for this simple question. However, I'm making a bot in my app where a check mark is automatically added to another column when my Emotion column value is Happy, Elated or Joyful. I competed the check mark part of the bot. But first part is giving me trouble.
Using one word is easy. This worked perfectly.
[EMOTION] = Happy
However, I'm not sure what to do when there's more than one word. I looked up and used LIST, SELECT, and then IN. I'm guessing I'm not using these functions correctly and probably need to swap something around. Any help would be appreciated. Thank you.
[EMOTION] = List(Happy, Elated, Joyful)
Solved! Go to Solution.
This might be what you need.
IN([EMOTION], LIST("Happy", "Elated", "Joyful"))
Also, consider CONTAINS.
This might be what you need.
IN([EMOTION], LIST("Happy", "Elated", "Joyful"))
Also, consider CONTAINS.
Thank you so much for this helpful information. It worked! I used CONTAINS because IN only worked if the value was set at the moment, whereas CONTAINS changed to a check mark even if the value was already set. Really appreciate it.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
13 |