Unable to Edit 1 Column on a Spreadsheet

SPO MPD

Hello all,

I am working on a collaborative spreadsheet on which I am an administrator. All I am trying to do update a vlookup function for one column, which references a different spreadsheet, on which I am also an administrator. The spreadsheet is currently some 40-50 columns wide, but for some unknown reason I am unable to edit any of the cells in the one column I need to. The column has conditional formatting attached to it, but the column is not locked, so I see no reason that I should not be able to change the text/formula in that column's cells.

Does anyone have any idea of what the issue here may be?

Kelly Moore

Hi @SPO MPD

If the column has a Column Formula in it, one cannot directly edit the column. There are two quick ways to see if a column has a Column Formula. At the top of the column you will see this icon

Or, you can right click on a cell and at the very bottom of the column menu you will see the options to EDIT the Column Formula or convert back to Cell Formula (the sheet default).

This information might be useful

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Kelly Moore

Hi @SPO MPD

If the column has a Column Formula in it, one cannot directly edit the column. There are two quick ways to see if a column has a Column Formula. At the top of the column you will see this icon

Or, you can right click on a cell and at the very bottom of the column menu you will see the options to EDIT the Column Formula or convert back to Cell Formula (the sheet default).

This information might be useful

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas