How can I document formulas used on a sheet?

BrooksN

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?

Michelle Choate 2

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