I was wondering if this is a feature or could become one.
Here’s my idea/scenario. I make a template of a chart. I can then send the chart to other users where they can edit their own individual data within the chart (or perhaps a single column while the rest is locked). But, I can also push out updates to add or edit changes in the template that applies to all users of that chart.
Example…
Quantity | Item | Store
1 | Monitr | Newegg
3 | Cable | Amazon, BestBuy
2 | Headphones | BestBuy
In this example, I would be able to share the chart with anyone. With their own account they could edit their version of the template’s quantity column. However I as the admin could make changes such as adding more stores (tags) to existing items, edit changes (like correcting “Monitr” to “Montior”) and adding new entries to the chart/list.
Is that something that’s currently possible? Is it something that could be implemented? Other spreadsheet and similar programs/services I’ve found let you share a sheet or let the user download a copy, but nothing where the originator can push out updates AND each user keeps their unique data. It’s especially an issue (with other programs/services) if you wanted to insert entries between other entries. You couldn’t simply download the new version and copy data from one column over, because when you paste it it wouldn’t be in the correct spot.