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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!