Search and replace in a rollup

I am using a smartsheet rollup template and have created multiple formulas tying to another sheet. Now I need to change a criteria within a formula that I'm using in multiple fields. Is there a way to search and replace in a rollup sheet? I've tried Control F, which brings up the Find/Replace with box, but it states "no matches found", so it doesn't seem to be reading within my formulas.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!