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.
Best Answer
-
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.
Answers
-
Inside of a report, cells with formulas are not editable. Does your cell have a formula that can't be seen in the screenshots?
-
-
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.
-
That is a good thing to note. Yes, you do need to make sure all the columns contain the cell. Interesting.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives