I have a table that I created to track resource allocation, and use that information to then report out to a graph in my interface to show based on the allocations, how much I would be expected to spend each month.
The setup for this is a bit of a workaround to solve for not being able to have multiple fields reported into a chart. This is working how i need, but it is prone for error if I do not manually link the months in the linked field.
I'm trying to create an automation, or solve this in any way that doesnt require me updating both the linked field and the fields that determine if a resource is active or not.
My hope is that I could create an automation that would check the Month Fields, and if a Month is set to active, it would then enter that Month into the Linked Months field - this way i could just update the allocation fields, and my report would always be insync with what months should be linked - See Image attached.