How to change a formula without affecting previous existing cells

Taonga

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"

Andrée Starå

Hi @Taonga

I hope you're well and safe!

Are you using a Column Formula?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Taonga

Hi @Andrée Starå, yes, i am using a column formula.

Andrée Starå

@Taonga

Then you'd only need to convert it back to a cell formula and then make the change for the rows where you want the new one.

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Taonga

@Andrée Starå

I have a workflow/automation running on this sheet, so when a new line is added, how can i avoid dragging the formula each time this happens but for it to automatically populate the cell formula for the new line?

Not sure if i am making sense.

Andrée Starå

@Taonga

The new row will be auto-filled with the formulas if there are two rows below/above with the same formulas and the same level of hierarchy.

More details:

If the formula structure is the same above/below the Formula Autofill will add the formula(s) automatically.

Conditions That Trigger Formula Autofill

You’ll see formulas populate automatically when you type in a newly inserted or blank row that is:

• Directly between two others that contain the same formula in adjacent cells.
• At the topmost of the sheet if it’s above two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• At the bottommost of the sheet if it’s below two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• Above or below a single row that is between blank rows and has formulas.

More info: 

https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

Did that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!