How to change a formula without affecting previous existing cells

Options
Taonga
Taonga ✭✭
edited 06/17/22 in Formulas and Functions

I have a workflow in which I am using the If formula(=IF([Funding Stream]@row = "BCP Core", "Kellys", "Mwamba")). I would however want to change the name "Kellyz" to "Elisa" but without affecting the previous results which already have the name "Kellyz"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!