Hi,
I'm trying to have one Column "Phone" show different numbers depending on what the user have chooses on the "user input control".
In this case it's different countries and all are listed as a value in "User input control".
I make it work with just one User input and variable, but the same column is suppose to show data from 4 different countries depending on the User input.
The data is presented in different sheets in the data source.
My formula works for just one like this:
((IF($Country="Finland",(REVERSE(SLICE(@Contacts FI,G:G;))),""))
I would like the column to present data for more than just Finland if the user input is another country, and I'm trying to do some sort of a OR formula
((IF($Country="Finland",(REVERSE(SLICE(@Contacts FI,G:G;))),""))
OR(((IF($Country="Sweden",(REVERSE(SLICE(@Contacts SE,G:G;))),""))
I hope my question is understandable!
Thanks!