How to Run Columns Based on No Result Found in Lookup Person Column

·

Hi! I believe somebody asked this before some months ago. I want to run the next columns ONLY IF the “Lookup Person” column has the result “No Persons Found”. Is there any way I can set up this? Or do I have to put formulas in each of the columns?

✅1

3 comments

· Sorted by Oldest

Ilze N.
·
·
https://app.clay.com/workspaces/35014/tables/t_Ud6F7pzJqOTe/views/gv_qojsAX9L79SP
Clay Team
APP
·
·
Hey Ilze, thanks for the question! Yes, the easiest way to achieve this is to give each one of them the same conditional formula. We brought the idea up to the team so there could be an option to add the same condition to several columns all at once but that's still on the roadmap. For now, you can generate it once and copy/paste in the rest of the columns you need it for.
Clay Team
APP
·
·
Let me know if you have additional questions!

Ilze N.
·
·
https://app.clay.com/workspaces/35014/tables/t_Ud6F7pzJqOTe/views/gv_qojsAX9L79SP
Clay Team
APP
·
·
Hey Ilze, thanks for the question! Yes, the easiest way to achieve this is to give each one of them the same conditional formula. We brought the idea up to the team so there could be an option to add the same condition to several columns all at once but that's still on the roadmap. For now, you can generate it once and copy/paste in the rest of the columns you need it for.
Clay Team
APP
·
·
Let me know if you have additional questions!