Ive got a problem. I want to get multiple rules in a switch statement.. But its not working, only if u use OR-statement i can add 1 more rule..
Sample of the data/formula(its anonymized):
Solved! Go to Solution.
I have a template i use for adding a switch with muliple criteria
you can replace the && with a || to get an or statment. and just use as many colunms as is needed
Give back a TRUE if ReferredID equals 1 of the 4 desired ID's and if the match with 1 of the UserID's...
If ReferredByID equals 1073 OR 440190 OR 39050 OR 28536
AND UserID equals 1028 OR 383575 OR 93233 OR 1013 then TRUE
else will give back FALSE everytime.