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.
Help Article Resources
Check out the Formula Handbook template!