why does the formula overwrite in one cell when I create a different formula in another cell in the
Is there are way to have different formulas in cells in the same column?? Every time I update one cell the other cell changes to the formula in the new cell and vice versa.
Answers
-
Right click on any cell in the column you are working on, then click "Convert to cell formula" all the way at the bottom.
Is this what you are looking for?
Sincerely,
Jacob Stey
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!