Avatar of Gilberto Sanches
Gilberto SanchesFlag for Suriname

asked on 

A formula in a protected sheet doesn't work for unauthorized people

Hi experts,

We have a google sheet with formulas in some column. The formulas are important to the whole functioning of the sheet. So in order to protect those columns from unauthorized changes we protected them.

Those columns calculate stuff based on input from other columns. Now when users input stuff into those stuff, the protected columns with the formula doesn't get executed for those people. Only for people who have edit permissions.


How can we solve this?
The formulas in the protected colums should work for unauthorized people. But the protection should prevent people at the same time for changing the formulas in those protected columns.
GoogleSpreadsheetsMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Martin Nguyen
Avatar of Martin Nguyen
Martin Nguyen
Flag of United States of America image

Do you have an example spreadsheet you can share?

I tried creating a sample spreadsheet with a basic formula in Column E. I restricted the range to only be edited by me. When I shared this sheet with others the formula updated.

Do you have multiple rules protecting the range?
ASKER CERTIFIED SOLUTION
Avatar of Gilberto Sanches
Gilberto Sanches
Flag of Suriname image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Martin Nguyen
Martin Nguyen
Flag of United States of America image

ahhh good to know! glad you got that sorted out
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo