Hi all! Maybe ridiculous question but I’ve been stuck with this for so...

Hi all! Maybe ridiculous question but I’ve been stuck with this for some time, so thought to better ask. I want to filter out to only those cells where “No Persons Found”. I tried to use a conditional formula but got this warning whatever I tried. I know that there must be an easy way out of this. https://app.clay.com/workspaces/35014/tables/t_82CbOgICI2zE/views/gv_k2zSJbKljNSh

11 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 😉
Ilze N.
·
https://app.clay.com/workspaces/35014/tables/t_82CbOgICI2zE/views/gv_k2zSJbKljNSh
Clay Team
APP
·
Hey hey!
Clay Team
APP
·
Hey Ilze N., happy to help!
Clay Team
APP
·
Sorry about this
Clay Team
APP
·
It looks to be working now, any chance it was in your trash bin on accident?
Clay Team
APP
·
Either way, it looks to be recovered now and working
Clay Team
APP
·
Let me know if you clicked "recover" for the table:)
Ilze N.
·
Matthew Q. thanks for looking into this! I’m not sure where I could have “recovered” it! I still face the same issue with different formulas I try. I just want to know if this is an issue with my formula writing style (I’m just learning so it’s plausible!) or if something is wrong with the table itself. can you help me once again?
Matthew Q.
·
Hmm sorry about that, super odd. I just tried this on your table and its working. There was a bug we fixed yesterday that potentially hasn’t updated for you. Can you try logging out and back in?
Ilze N.
·
·
It worked! Thank you so much!