Can you please add a find and replace feature that can edit formulas within the selected cells?

Adam Kinney

This would be a huge time saver! Similar to what is explained here (Find and Replace Values Within a Sheet | Smartsheet Learning Center), but adding the ability for it to adjust formulas.

Genevieve P.

Hi @Adam Kinney

That's an interesting idea! You can adjust cross-sheet references by using the Sheet Reference Manager (see here), but you're right, there's no way to use Find to search through formula expressions. When you have a moment, please fill in this form to let our Product team know of you idea and detail how you imagine it to work.

Cheers,

Genevieve

Genevieve P.

Hi @Adam Kinney

That's an interesting idea! You can adjust cross-sheet references by using the Sheet Reference Manager (see here), but you're right, there's no way to use Find to search through formula expressions. When you have a moment, please fill in this form to let our Product team know of you idea and detail how you imagine it to work.

Cheers,

Genevieve

Digikiwam

You can click on the cell that has the amended formula and turn it into the column formula. this will replace all the formula's in that column with the amended formula. Only good if you are replacing the entire column formulas though, not specific cells in your sheet.