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

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!