What is your goal?
I want a scheduled automation that checks a few conditions on items and subitems and then changed the value of the Status column to Ready to Start when they all apply.
What is the problem?
I have part of another Monday automation in Make that changes the status of an item (or subitem) to Ready to Start if certain conditions are met (no Dependency, no subitems, and either start date before today or today or if no start date, due date before today or today)
It’s working fine when a date is changed, but if no date is changed and the date arrived, it’s not automatically updated. That’s why i need something similar but scheduled.
What have you tried so far?
I tried with GraphQl to get the items and subitems already filtered to limit the amount of credits used to run through it, but it’s not working how I want it to. It’s kind of working but using a loot of credits since it’s running through all 10 boards and items and subitems. I want to add a filter as soon as possible on my conditions, but with subitems being on different boards and having different column IDs, it’s turning out difficult.
Apologies for my scrappy diagram, I’m still learning.
Create public scenario page