Creating a Run Condition for Multi-Step Process in Spreadsheet
Hello everyone, I was working on a clay project and ran into an issue. Can someone help me find the solution to this? I have a multi-step process with the following:
- 1.
2 URL finder columns – If 1 fails other will run.
- 2.
5 corresponding scraper columns – These should:
Run if a URL is found.
Not run (showing "Missing input" or "Run condition not met") if no URL is found.
Even if they run, they might return an empty result.
- 3.
5 post-processing columns – These are supposed to process the content returned by the scrapers:
They should run only if the scraper returned a result.
If the scraper ran but returned an empty result, the post-processing column might not run (depending on its run condition).
Now, I want to add one more column at the end that should only run if all of the above steps have been completed:
URL finders have attempted their work.
Scrapers have either run or correctly skipped (due to missing input).
Post-processing columns have either run or correctly skipped (due to empty scraper results or run condition not met).
So in short: I want to write a run condition for this final column that checks whether all 12 columns (2 URL finders, 5 scrapers, 5 processors) have done whatever they were supposed to do — run when they should, or be skipped for valid reasons. How can I create a condition for this?