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

Philip Kolmar

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.

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.

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

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.

Mike Wilday

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