This is a great template!
The issue I'm having, is, I want to add a column to have the company name.
Once I do that, all the dashboards and destroyed and don't work anymore cause the master sheet doesn't / hasn't seen this data before.
What do i do?
First you need to ensure that you are adding the new column consistently on all sheets that the template is using. Check your workflow overview to see which files are connected.
Second, the dashboard probably broke because you added the new column somewhere in-between the existing columns. Never do that. Always add new columns at the end of the already existing column layout.
That put me in the right direction.