Hey Remen, thanks for reaching out! π
I noticed there were some errors in the formula. Hereβs what I did to fix it:
1. I took a screenshot of the formula in the Loom video.
2. Sent it to ChatGPT to return the formula as text.
3. Copied the formula and replaced {{Unique ID}} with the actual value in the table using the forward slash (/).
4. Finally, I force-run the entire rows, and it works now!
For future reference, feel free to save this formula:{{Unique ID}} ? ({{Lookup Multiple Rows in Other Table}}?.records?.findIndex(record => record['Unique ID']?.toLowerCase() === {{Unique ID}}?.toLowerCase()) + 1 || 2) : 2
Let me know if you need anything else! π