Enhanced Formula Editing - Mass Changes to Formulas on Sheet

DataDaveRN

Quite often, I am entering the same formula, with the only differentiation being an identifier for a unit or job role. This becomes tedious and is a very manual process. In Excel, the ability to find and replace eliminates this repetitive manual changing to a few keystrokes. Looking for the same functionality within Smartsheet.

Erin Horiuchi Green

@DataDaveRN Have you tried creating a cross-reference Smartsheet to help logically identify the Unit or Job Role?

Then you can implement into your formula a VLOOKUP to the cross-reference sheet.

CatSusk

Hi,

I'm running into the same issue right now. How exactly would you do this with a cross-reference sheet?

Chris_C

I would absolutely love the ability to mass edit formulas with some sort of "replace all" feature.

For our instance, I have multiple metric sheets or reports referencing a project name so the rest of the formula is the same but the "CountIF" needs to use the project name as a criteria. Having the ability to mass edit formulas in a sheet or report would save me HOURS