Check-in list with multiple users, but each user only has access to their team
We have a group of supervisors that are each responsible for their own techs. I'm looking to create a spreadsheet for the entire team, where each supervisor only sees their own group to check off. They would be responsible for the "Ops Check-in" and Notes column.
Once they've submitted their team, another single person is responsible for the "Keyed" column. The fully completed checklist for the whole team would then need to be submitted by the person who keyed everything.
From my research, I think my best bet is Power Query, but I've never used the tool. I've got all of the supervisors separated into their own sheets, and each sheet is formatted as a table, but I'm not sure where to go from here. I've also tried this in Microsoft Lists, but to no avail.
[link] [comments]
Want to read more?
Check out the full article on the original site