Summaries in Reports
Hi,
This has probably been asked numerous times but I just can't find the answer but I can't believe it isn't possible.
I am making a simple equipment inventory with servicing data within it. The services are carried out on a 1,2 or 3 year rolling cycle, so I want to be able to print off a report at the start of each year to show me all of the services that are due to be carried out.
I would like to include a very simple summary of that data in the report such as the total number of services due, and the total cost associated. But there doesn't seem to be a straightforward way of doing it.
Any help would be greatly appreciated
Chris
Answers
-
You would want to create a new sheet (or find some space on the current data sheet) and use formulas to pull those metrics.
From the sound of things, those formulas would most likely end up being relatively straight forward.
But you cannot reference reports in formulas to pull metrics.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 383 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives