Hi all,
I am working with @Deyanira_Almada and wanted to crowdsource if anyone has figured out the best way to handle a complex contract situation:
Industry: Hospitality
Contract Type: Staffing
The Staffing Agreement with each agency is a Master Agreement. It will be amended frequently as locations are added or removed and new positions are added or removed.
The number of locations, and the number/types of positions at each location, could be infinite. As of now, the most they have had is 17 but as they are a growing company they expect this to only increase.
What we really need is essentially a dynamic table within a dynamic table, which we know isn't possible today.
See the attached screenshot for a flavor of the information. It's presented in tables right now but we are agnostic as to format (and are happy to change the format to make it work). If anyone has any creative ideas of how to achieve this with formulas/dynamic tables, I'd love to hear your thoughts!
Laurel
