Column Formula + Reports

holli.nunn

Curious why a column that has a formula applied cant be changed when it's pulled into a report - from the report?

Also wondering if there is a way that is quick to remove the formula from an entire column? I've switched one back to 'cell formula' to allow for edit from the report but, would like to avoid running down 600 cells to manually remove the formula from each.

Paul Newcome

Yes. It will delete the data since you are deleting the formula. If you want to keep the data but remove the underlying formula, you will need to convert it to a cell formula, copy all of the cells, then "Paste Special / Values".

Paul Newcome

Once changed to a cell formula, you can click on the column header to select the entire column and then hit the delete key on your keyboard.

holli.nunn

Will that also delete the data in the cell? Its a date column.

Paul Newcome

Yes. It will delete the data since you are deleting the formula. If you want to keep the data but remove the underlying formula, you will need to convert it to a cell formula, copy all of the cells, then "Paste Special / Values".

holli.nunn

Thank you @Paul Newcome

Paul Newcome

Happy to help. 👍️

Janelle L

Can the "Paste/Special Value" work with sheets that have more than 500 rows? we need to replace formula with the value only for over 6000 rows.