Using array columns as part of IF Then Else

Ask for Help
1

Hi,
Hopefully a simple one - I have an array - The Client Choice PIN in this example, and I’m trying to use this array in a IF Then Else column but it only provides is empty or is not empty options whereas I’m after a contains option. Is there a way of getting around this?
What I am trying to accomplish is to compare a user entered PIN with the array to provide a true/false column that I can then use to filter on. E.g. If Client Choice PIN contains Entered user PIN then true.

array
array1114×372 36.8 KB

2

I’ve wanted this for a couple of use cases as well. Doesn’t exist at the moment.

3

Thanks Robert. I have tried doing it by creating a template column which ‘converts’ the array into a text string and this works but doesn’t allow for dynamic updates for adding options as you would need to go into the Template column and update it.

4

Makes sense. Nice workaround for now, though!

5

You taught me the Template trick :wink:

6

Nice job, me! :upside_down_face:

2 Likes
7

I’m not sure where your user entered pin comes from, but what if you create a relation that would link the user entered pin to the pin column in whatever sheet contains the pins. Then create an if/then column or simply use the condition if the relation is empty or not to control what you need?

1 Like
8

Thanks Jeff but I’m not sure that’ll work in this case - I’ll give it a go

1 Like