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!
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
This should be straightforward information but I can't find it anywhere. How do the Automation triggers work for attachments? I assumed: An attachment is Added = New attachment An attachment is Changed = New version of existing attachment. But I just had an 'Added' attachment notification trigger when I uploaded a new…
