Clay Icon

Creating Conditional Lookup in Google Sheets Based on Previous Runs

·
·

For the google sheets lookup enrichment, how would i write a formula that makes this only run if this lookup has run before, whether or not theres a result or not, and not just if there was no return value?

  • Avatar of Yan S.
    Yan S.
    ·
    ·

    Separately, when i filter on a look up from a different clay table, i see these options, but what i want to see is all rows that have been run (whether there was a result or no result). None of the options below give me that, I can only see the following, but there's no "Has run" option. Am i missing something? has an error does not contain an error has results - Run with result has no results - Run with no result has not run - Not Run run condition not met

  • Avatar of Yan S.
    Yan S.
    ·
    ·

    Hey Bo (., would you mind taking a look at the first post in this thread? I'm trying to set the rule such that this only runs if another column has run

  • Avatar of Yan S.
    Yan S.
    ·
    ·

    Thanks Bo! The follow up to my first post is more like a workaround because i couldn't figure out how to write that rule, hence i was trying to filter for both run with results and run without results

  • Avatar of Yan S.
    Yan S.
    ·
    ·

    Hi Bo (., i didn't see the text on how to write the formula above

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Do you see it now? I'm going to send it via slack instead of intercom. Sorry for the mixup

  • Avatar of Yan S.
    Yan S.
    ·
    ·

    I see it now, thanks! Related question: https://clayrunhq.slack.com/archives/C025KSBLPGX/p1725386509892069 If i change this rule halfway, does it cause all the previous values to re-run again if i click run again or if i turn on auto update?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    I've replied to it :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Yan S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback Yan S.!