How to link data in two sheets via a report?
Let's say I have sheet #1 called SiteData with columns SiteID (autonumber) and SiteName (text)
Let's say sheet #2 called TimeData with columns SiteID (text/number) and TimeData (text)
How can I get a report to link the data between both sheets so that it can group TimeData with SiteName via the SiteID? Such as creating a summary of total number of TimeData rows related to the Sites...or...show a graph for each site showing the dates related to the site.
Is this possible in Smartsheet?
Answers
-
summary of total number of TimeData rows related to the Sites
This you can do, but not with a Report. You do this with COUNTIFS. Use COUNTIFs in Sheet1 and reference the SiteID range in Sheet2.
It seems like the "graph for each site showing the dates related to the site" can be accomplished using Sheet2, with a VLOOKUP or MATCH/INDEX to look at Sheet1 to get the SiteName.
If you ultimately want a report, you can base a report on either of those sheets.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 358 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives