How can I document formulas used on a sheet?
I have a fairly involved project management solution using multiple sheets, reports and dashboards, and want to document the inner workings of the sheets in the event we have to recreate them. The SmartSheet backup system will back up the data but not the actual sheet itself leaving me to recreate all of them and remember the involved formulas for each column or cell. Is there a way to show the formulas in a cell instead of the actual number value? In Excel there is a button in the "Formulas" tab to "Show Formulas" that lets you see the formulas for each cell instead of the numerical value. I am looking for something similar so I can print that to PDF and save it as a record just in case. Is there a way to do this or something similar?
Answers

Yes and no. No  there is not a way to just print it and have them show. Yes  you can alternitvely, go into every column, remove the = sign, then view the text of the formula only. Or alternatively put: ="Your Formula" in quotations to just display text. Then you can print, then go in and undo whatever alternative you choose
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
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!