Looking to prevent anyone from overwriting a column that has a formula. This is currently not possible, correct? Owners and admins can always overwrite a cell's formula?
Thanks,
AEG
Correct, you would need to allocate everyone else editor permissions or lower to be able to have that sort of control.
Hi Andrew,
How would you use it? What's your use case?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
A potential workaround could be to publish the sheet.
Would that work?
Andrée
Hi Andreé,
The purpose of the column is for display purposes only -- no data should be put into the column
Or... add every column to a report. This will mean the data will already need to be there, but the changes can be made by admins and yourself to any column except for the formula column.
Happy to help!
Ok. I agree with Lachlan then to use a Report but know that the users that are shared to the report can open the sheet and make changes according to their permissions.
Hope that helps!
Hi All, I have a sheet that I am creating to gather powder coat thickness data. The problem I have run into is that they can do up to 5 checks on the same line during the same day and shift. Then they get the average of those measurements to use for the day to determine if the thickness passed or failed. If I have a form…
Hi All, Need you support for the the issue. I was in the process of making an approval workflow for petty cash request, the problem was when i want to combine 2 different confirmation workflow by Requester to be appear in same column (Confirm), but mention notification like in the screenshot attached. The workflow consist…
New to smart sheet pro and I desire to share to viewer, share tab not activated...how do I activate and share a sheet with a viewer?
