Remove Block of Data based off Agent

[rphillips4665]

I am working on a schedule and want to be able to add a button to remove an agent and that will delete the corresponding rows that are attached to that agent.

In the attached file I would like to remove agent 2 and their entire schedule.

[jindon]

Try the attached.
Your formula will not work when any of the rows are deleted, so changed.

Please Login or Register  to view this content.

[rphillips4665]

Try the attached.
Your formula will not work when any of the rows are deleted, so changed.

Please Login or Register  to view this content.

This did the trick.

Thank you!