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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!