Column Formula + Reports

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.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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".


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!