Shane P.

UPDATE: Found why the Formula wasn't labeling the occurrence correctly (adding this hear just incase others come across a similar issue) I needed to force run the lookup multiple rows in other table column so the name "Unique ID" or "random 10-digit number" was being searched properly within the formula. Remember the lookup multiple rows function is not dynamic and wont pick up name changes after its run!

I have tried to replicate but running into issues. This is where I am:

Only run if /Random 10-Digit Number is not empty, then return a number label depending on which number of occurrences any of the "Random 10-Digit Number" fields from /records match /Random 10-Digit Number. For example, if the first value of "Random 10-Digit Number" you find from the array is true, then return 1, if it's the second value then return 2 and so on.

Attached are a few screenshots of the formula generator and the output, could someone let me know what I am doing wrong 🙂