Sign in to submit new ideas and vote
Get Started

Update Formulas via a "Find and Replace" Method


I have a Smartsheet Metrics file with a lot of formulas. I understand if the Metrics sheet is provisioned with Control Center, this would accommodate the functionality I'm looking for. In my case, the sheet is not provisioned with Control Center as it is pertinent to our overall Portfolio of initiatives and not just the Active initiatives managed within Control Center. I am looking for the equivalent of a "Find and Replace" function to update all formulas in the sheet. The current Find and Replace doesn't work for formulas. I realize the workaround would be to create a "Helper" column for the replacement, but would prefer not to create these columns.

5 votes

Idea Submitted · Last Updated