Any Idea why a formula would change ?

Dakota

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?

Genevieve P.

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

Genevieve P.

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