Sign in to join the conversation:
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!
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
