Update Formulas via a "Find and Replace" Method

Mike Dufour

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.