View formulas globally in a sheet
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to:
- Discover which columns I want to shade grey to indicate that they shouldn't be manually edited
- Find any rows/cells where the formula didn't get copied over
- Making sure the formulas are consistent
- Generally getting a look at the formulas
I've looked everywhere but I can't find a way to do this in Smartsheet. Currently I have to click in each cell to see individual formulas.
Thanks for any advice / considering adding this feature!
Comments
-
Hello,
Smartsheet currently doesn't have a keyboard shortcut to toggle viewing underlying functions vs their return values. When you have a moment, please submit a Product Enhancement Request using the form under Quick links on the right of the community site to let our Product team know that you'd like to see this feature added to Smartsheet.
Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!