Any Idea why a formula would change ?

Dakota
Dakota ✭✭
edited 12/23/21 in Formulas and Functions
image.png

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

  • Genevieve P.
    Genevieve P. Employee
    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

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

Answers

  • Genevieve P.
    Genevieve P. Employee
    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

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!