Sign in to submit new ideas and vote
Get Started

Formulas used in worksheets

Before I create a sheet, is there a way to have SS automatically log and track when I use a formula? I am guessing @Paul Newcome and @Genevieve P. have helped me dozens of times. So I don't have to keep going back to them, I am going to try to create a sheet that displays the FORMULA, lists the sheet it is located in maybe an notes field.

Would be great if this could be auto populated... when I build new formulas.

I fear that when I try to recreate the data exampled in the first pic, all but a few of those data sets are formula generated, pulling from numerous other sheets. If I try to screen shot print and document via ink to paper, I'm bound to miss "({,@ or other symbol ....

SS_FormulaTrack.jpg SS_FormulaTrack1.jpg


3
3 votes

Idea Submitted · Last Updated

Comments