Microsoft Form data into Online protected sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-312178%22%20slang%3D%22en-US%22%3EMicrosoft%20Form%20data%20into%20Online%20protected%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312178%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20build%20an%20online%20sheet%20that%20is%20a%20combination%20of%20survey%20data%20columns%20from%20MS%20Form%2C%20user%20data%20entry%20columns%20and%20formula%20columns.%20Basically%20it%20is%20a%20live%20team%20project%20tracker.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20protect%20the%20sheet%20from%20being%20edited%20by%20users%20except%20for%20the%203-4%20user%20update%20fields.%20That%20is%2C%20I%20want%20the%20form%20data%20and%20the%20formula%20data%20protected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20found%20that%20when%20I%20protect%20the%20columns%20that%20are%20being%20populated%20by%20the%20form%20data%2C%20they%20stop%20updating%20when%20a%20new%20form%20is%20submitted.%20It%20says%20Sharepoint%20App%20is%20Editing%20but%20no%20updates%20are%20made.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20unprotect%20the%20sheet%2C%20new%20form%20data%20gets%20loaded%20as%20normal%2C%20but%20survey%20responses%20are%20no%20longer%20synced.%20So%20there%20could%20be%2010%20responses%20in%20the%20Form%20but%20only%208%20in%20the%20sheet%20because%20it%20was%20protected%20whilst%20the%20other%202%20were%20being%20created.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20give%20the%20form%20permission%20to%20update%20the%20sheet%2C%20but%20not%20any%20other%20user%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20any%20other%20workaround%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-312178%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

I want to build an online sheet that is a combination of survey data columns from MS Form, user data entry columns and formula columns. Basically it is a live team project tracker.

 

I want to protect the sheet from being edited by users except for the 3-4 user update fields. That is, I want the form data and the formula data protected.

 

I have found that when I protect the columns that are being populated by the form data, they stop updating when a new form is submitted. It says Sharepoint App is Editing but no updates are made.

 

When I unprotect the sheet, new form data gets loaded as normal, but survey responses are no longer synced. So there could be 10 responses in the Form but only 8 in the sheet because it was protected whilst the other 2 were being created. 

 

Is there a way to give the form permission to update the sheet, but not any other user?

 

Or any other workaround?

0 Replies