Replace values within all cells in a sheet

Hello. We are using smartsheet to create time cards. I am looking for a way to possibly run an automation where is searches every cell within the sheet and finds lets say "John Johnson" and replaces it with "Jane Doe" as I need to make timecards for each employee.

Any advice or guidance would be much appreciated.

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!