Forum Discussion
soumyas1111
Feb 06, 2021Copper Contributor
Hi! Can anyone help me on how to put formulas as a drop down list in a certain cell?
I was going through excel sheet formulas for sales team target & I came across a sheet that is formulated. I really want to know how to put the formulas as options in a drop-down as shown in the pict...
SergeiBaklan
Feb 06, 2021Diamond Contributor
To my knowledge that doesn't work such way. If you are working with structured table, list of aggregation from drop-down is only in Total row at the bottom of the table. On the top, or at any other place, you only could make the reference on Total.