Am I missing something - adding formulas in sheet summary?

Phil Wightman

When I attempt to set a formula in sheet summary the wizard give one option of ‘Refernece another sheet’ and not the sheet you are in. When I click click on the column header in the sheet (i'm in) to set the range this is what I get this:

This is different to adding a formula to a cell in a (metrics) sheet where you can click on a column header to add the the range.

Stefan

Hi @Phil Wightman,

no, you are not missing something. Wether in the sheet, or in it's sheet summary, you can never just click on a column header to ad the range to a formula.
This only works, when selecting another sheet as reference.

If doable within the core application this might be a nice improvement for smartsheet. So, if you like, hop over to the https://community.smartsheet.com/categories/smartsheet-product-feedback-%26-ideas section and post this as a new idea :-)

Greetings

Stefan

Stefan

Hi @Phil Wightman,

no, you are not missing something. Wether in the sheet, or in it's sheet summary, you can never just click on a column header to ad the range to a formula.
This only works, when selecting another sheet as reference.

If doable within the core application this might be a nice improvement for smartsheet. So, if you like, hop over to the https://community.smartsheet.com/categories/smartsheet-product-feedback-%26-ideas section and post this as a new idea :-)

Greetings

Stefan