I'm having issues using the Array Position formula provided by the Clay team - more details in this Loom: https://www.loom.com/share/6c8b7bf9edd24efabfcdeea8b0d93898 here's the video guide I received for numbering rows: https://www.loom.com/share/42c7f8be9bbd4ca69165e01d6377dd01?sid=f0234a49-0e17-4ae6-ac96-799aa40d53eb Link to Clay table: https://app.clay.com/workspaces/354814/workbooks/wb_yminVz8MSaiB/tables/t_Ytki9s879ZBb/views/gv_vKGRmkqyXGgi
π Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
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! π
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!