Is there a way to ONLY have one cell unlocked?

Hi all,

I have created a sheet full of formulas that ALL reference one cell. I would like to lock down everything BUT that one cell, so functionally anyone with access could change the reference cell and see the consequence of that change.

I realize that I COULD move this one reference cell into its own column, but before I mess around with my formatting, I thought I'd check to see if this was a possibility.

The formatting of the page is important and it wouldn't translate into a dynamic view.

Thank you!

Meredith

Find more posts tagged with

Sheets

formatting

Accepted answers

All comments

AravindGP

Hi @Meredith Rhodes

You could have this cell added in Sheet Summary instead and create a column in your sheet which references this field. This way, all your actual sheet columns are locked for edits and only the Sheet Summary field is editable.

Meredith Rhodes

Thank you, @AravindGP - that is a clever way to do it.

Meredith Rhodes

What I'm trying to do - visually.

The top row in the 'Responsible Practice' column is a public clinical trial registry identifier. I've locked all other columns - but if I keep it formatted this way, I can't find a way to lock all but the top cell in the 'Responsible Practice' column. I'm hopeful that I can share what I'm making with people unfamiliar with smartsheet and simply say 'change the NCT Number'.

Maybe I can lock the column and make a form that changes this cell?

AravindGP

Hi Meredith,

Thanks for the screenshot. It is much clearer now. A form will not work. You can lock all the other rows, except for the row which contains the number. This way, your editors will only be able to edit the number in row# 1

Meredith Rhodes

OOOOOHHHHH, I see that now. I haven't locked a row before, obviously. Thank you for this direction.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.