Reply To: Formula in Sampler

#6550
Bill Finzer
Keymaster

Hello Patrick,

Assuming your cards are labeled like “5S” or “JD” this formula worked for me:

(charAt(first(value),2)=”S” or charAt(first(value),2)=”C”) and (charAt(last(value),2)=”S” or charAt(last(value),2)=”C”)

See the screenshot for the setup. Oh, and be sure to label the ten cards with a “T” rather than “10” since the latter will throw the indexing off.

Good luck!

Bill