Login Page - Create Account

Support Board


Date/Time: Thu, 03 Jul 2025 05:12:31 +0000



Post From: Changing column titles within spreadsheet formulas

[2020-04-22 19:28:14]
a Gem Tree - Posts: 60
I have a very long formula, which I would like to replicate some 40 times.
In each of the 40 iterations of the formula, there are about 12 references to column BS3, and I would like to change BS3 to something else, without changing each iteration 12 times.

I remember Sierra Techs mentioning this was possible, but I do not remember how to do it.
If you can help, that would save me a ton of time. Thank you!
-GT
Date Time Of Last Edit: 2020-04-22 19:29:19