How to Stop formulas from changing globally
This is my formula...
They look fine across the first row...
But if I copy the formula to another row and change the reference, all the cells change.
This is NOT what I want.
Can anyone help?
Best Answer

Happy to help. 👍️
Answers

You'll have to provide more information. When you say you're changing the reference, you're changing it from what to what? That change could very easily lead to different results. Also, what are the expected results you're looking for?

Thank you, Mike. The formula is referencing another sheet. This one (below).
I want my formulas to perform a COUNTIFS function by pulling from these different columns (above). The first row (below) works fine.
But I write the formula for the second row and I change the reference to another column in the source file, all the formula change (including the formula in first row), which I don't want.
I don't want any of the formula in other rows to change at all, but I seem to have no control of that.

Instead of clicking on "Edit Reference", highlight the entire cross sheet reference so that it changes to "Reference another sheet".

I'll give it a try. Thank you, Paul.

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!