Setting advanced (for me) reminder on subitems columns

Platform discussions Special workflows & use cases
,
1

Hello friends,
I need your help with building a workflow.
I want to get notified after some days from actual date by it’s a bit advanced as it’s all in subitems.
On my board I have:

Board structure
Board structure1427×343 29.9 KB

The actual date and I have number of days.
I want to get a reminder once 50% of the time has passed.
I add a formula column to calculate {Days}/2 so I get the number of days I want use for the reminder.
I also manage to calculate the reminder date and set it in Formula column, the thing is it doesn’t support reminders.
Now, I can’t use this automation as it doesn’t support neither subitems not formula columns:
automation
I can’t use General Caster as it doesn’t support subitems.

I tried to do it with Zapier but couldn’t figure out how to do it.

Any suggestions?

Thank you.

2

@Hezibo

Here’s what it would take to do that in Make:

image
image2902×1470 259 KB

You can find out more about Make here: What is Make & How can it help you with monday?

Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (monday, Make or “Rocket Science”)

3

Thank you very much @JCorrell
Do you know if it’s possible to build the same workflow with Zapier instead of “Make”? (Our team works with Zapier.

4

@Hezibo

Probably. I no longer use Zapier. Make is better in my opinion and about half the cost.

Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)

5

Thank you @JCorrell
I’ll check that.