Clay Icon
Join the Community
02 Support

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

Avatar of Ilze N.Ilze N.
·
·

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?

3 comments

  • Avatar of Clay Team
    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.

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Let me know if you have additional questions!