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?

10 comments

Yan S.
·
·
Here's the table: https://app.clay.com/workspaces/308568/tables/t_G3ZDEaVjUe6t/views/gv_AzPH6gsBuers
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
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
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
Yan S.
·
·
Hi Bo (., i didn't see the text on how to write the formula above
Bo (.
·
·
Do you see it now? I'm going to send it via slack instead of intercom. Sorry for the mixup
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?
Bo (.
·
·
I've replied to it :)
1
Channeled
APP
·
·
Hi Yan S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Yan S.!

Creating Conditional Lookup in Google Sheets Based on Previous Runs | Clay