Am I missing something - adding formulas in sheet summary?
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.
Best Answer
-
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
section and post this as a new idea :-)Greetings
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Answers
-
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
section and post this as a new idea :-)Greetings
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!