email automation for children
I am interested in creating automation to send an email when a date is past. I would like the automation to focus on the lowest level of hierarchy to assess whether the date has passed. I intend to make one assumption that a parent row always has "Knowledge Sessions" to indicate the automation follows.
Notice the red "Knowledge Sessions". I would like to assess the date for any rows at the lowest level beneath "Knowledge Sessions" and send an email if needed.
So "Proof of Concept 9am - 12pm" would be assessed. As would: "ETM Overview - 2pm-4pm -" and "EWS & EWS Inbound Interface - 1pm-4pm "
But not "Day 1- Proof of Concept/Intro ETM"
Is that possible?
Help Article Resources
Check out the Formula Handbook template!