Need Help To Target Parent Children Field to Trigger Update Request Communication

Radhika
Radhika ✭✭✭
edited 11/21/23 in Formulas and Functions

Requirement :

  1. Email notification cascades to other parties as previous tasks get [Status]completed so that they can start the next task.
  2. 1.Due Time for first child to take the timestamp from parent and add duration 2. For other children look at the sibling above
  3. Auto Numbering column for Parent and Child

Assignee at level 2 -ABC,3-PQR,4-LMN. When level 1 task is completed sent out email communication to level group 2 that task is ready to be worked on.

Parent will have created date, the time stamp can be used by first child to calculate Due time by Adding created + Duration

For Second Child - First Child Completed Closed time +Duration and so on for the parent

Thanks,

Radhika


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!