Cross-sheet formulas - affecting two cells when only one selected

Hey,

I am cross-referencing "total paid" from a budget sheet into an over all activity sheet; however, I have two cells (in the activity sheet) that though I am selecting different sets of figures (from the budget sheet) in the formulas they keep reflecting the other. when i change one, it changes the other. and visa versa. its like hey are linked. but i haven't linked them ???

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!