Because I have had to consolidate multiple lists, I have ended up with...

Because I have had to consolidate multiple lists, I have ended up with a number of cols of company website URLs - and I now need to consolidate them into 1 col. I have this formula which works correctly in the dialogue box - but does not seem to run in my table - help!

12 comments

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Ian M.
·
https://app.clay.com/workspaces/109036/tables/t_WEG3EeS8PYMF/views/gv_1SwJanogSOwT##
Ian M.
·
Oh, maybe it IS working, its just populating parts of my (5k row) table that is not on my screen. How can I tell? There is no spinner in the table header as there is when an enrichment is running
Clay Team
APP
·
Hey Ian, thanks for reaching out! Yep, since it's not like an integration column it just runs calculations right away. It usually takes 3-5 mins if you have several thousand records but as long as you see a few popping up near the beginning its a good sign
Clay Team
APP
·
Will ask if there's an indicator if it's running or not that we could add to it.
Ian M.
·
Its now more than an hour later and there are still rows missing
Ian M.
·
So something is not working
Ian M.
·
Help!
Clay Team
APP
·
Hey Ian, it looks like the issue is the "company URL" column next to it, the source data it was pulling from is missing and caused the final formula to stall out for a bit. It should work after that, Ian M.
Clay Team
APP
·

18f62546-1683-46e0-b199-0b962f07ff38.png(49 kB)
Ian M.
·
Ok, I'll delete that col to simplify things
Ian M.
·
Thanks

Because I have had to consolidate multiple lists, I have ended up with... | Clay