How do I prevent my sheet from "updating all my formulas across the sheet

Sue van Niekerk

so i have 4 "Tables" in A Sheet -

2 use a SUMIF( using quantities and one using %%) and

2 use a ERRORIF ( 1 uses qties and 1 uses %%)

But when i fix a formula in one cell it updates the whole sheet to be the same as i have just done

I have even tried retyping the formula into a new cell but the same thing happens

all the formulas are referencing the same sheet just pulling and reporting different types of data for the tables

Andrée Starå

Hi @Sue van Niekerk

I hope you're well and safe!

It sounds like you're using the Column Formula feature, so when you change a formula in one cell in the column, all will update.

To make changes to individual cells, you'd either have to change it back to cell-based by selecting, Convert to Cell Formula or structure the formula to check for something like the level or something else to identify what the formula should do.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Sue van Niekerk

I hope you're well and safe!

It sounds like you're using the Column Formula feature, so when you change a formula in one cell in the column, all will update.

To make changes to individual cells, you'd either have to change it back to cell-based by selecting, Convert to Cell Formula or structure the formula to check for something like the level or something else to identify what the formula should do.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sue van Niekerk

HI Andree

Yes we are very well and safe here in Western Australia.

What i did was when linking to a sheet ( the same sheet) i changed the name of the range to avoid it changing- your way looks so much easier so will remember that for my next sheet :-)

again as always you have been a big help!!

Andrée Starå

@Sue van Niekerk

Glad to hear you're well!

Happy to help!