Why are some cells editable and some not in a row summary report?

I created a summary report that our editorial team mostly uses as a reference, but there are a few fields that they'll need to update manually, the "editor" column being one of them.

I discovered when creating the summary today that the editor column cells are grayed out and can't be edited. There is no difference between this column and my "title" column which has the blue line around it instead of gray and CAN be edited. What is differentiating these columns?

images included for reference.

Screen Shot 2021-01-22 at 4.37.41 PM.png

Screen Shot 2021-01-22 at 4.37.06 PM.png

Find more posts tagged with

Accepted answers

Philip Kolmar

I was able to resolve this. It turns out that the editor column existed in most of the sheets I was referencing, but not all. It was grayed out when I was trying to edit "editor" in a sheet that didn't contain that column. Sorry for what ended up being a silly question.

All comments

Mike Wilday

Inside of a report, cells with formulas are not editable. Does your cell have a formula that can't be seen in the screenshots?

Philip Kolmar

Thanks for asking, @Mike Wilday. Neither that cell nor that full column uses formulas at all.

Pip

Philip Kolmar

Mike Wilday

That is a good thing to note. Yes, you do need to make sure all the columns contain the cell. Interesting.

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.