Any Idea why a formula would change ?

This If error statement was manually typed in but the sheet. It never said FM pilot2. The sheet changed the text without me knowing.
What would cause this?
Best Answer
-
Hi @Dakota
If a column name is referenced in a formula, and then afterwards someone changes the name of that column in the sheet to something else, the formula will automatically adjust to show the correct, new column name.
In your instance, you can see that it's recognizing a column in your sheet because it's highlighted in a specific colour. It looks like someone added "FMPilot2" to the name of the column in the sheet.
See: Create a Cell or Column Reference in a Formula
Cheers!
Genevieve
Answers
-
Hi @Dakota
If a column name is referenced in a formula, and then afterwards someone changes the name of that column in the sheet to something else, the formula will automatically adjust to show the correct, new column name.
In your instance, you can see that it's recognizing a column in your sheet because it's highlighted in a specific colour. It looks like someone added "FMPilot2" to the name of the column in the sheet.
See: Create a Cell or Column Reference in a Formula
Cheers!
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!