Find and Replace Formulas in SharePoint Calculated Columns
Something often overlooked during migrations are calculated fields in SharePoint Lists. In lots of tools available, the value of a calculated field migrates correctly from one environment to the next. The problem though, is in one environment this formula may have pointed to a URL or static asset as part of the formula. After this column is migrated the formula is technically correct, just inaccurate in the new SharePoint environment. Following a migration from SharePoint 2007 to SharePoint 2013, my…