How do I integrate three sheets together?
I’m trying to design a new sheet structure and need some ideas. Let’s say for example I have one table that has Computers and another table that has Applications. A third table (App Records) contains a reference to both on a one to one basis. Each computer has multiple applications and each application is linked to multiple computers. Each line in the App Records sheet has a pointer to the related computer and related application.
I want to be able to create a form in Computers that shows all the Applications for that PC.
Lastly, I want to know if there are any limits to number of Applications which can be associated or displayed for the Computer. I have a listing of 8k computers, 15k applications and around 120k app records (although that number can be reduced if needed).
Answers
-
How many applications maximum do you need to track on a single computer?
-
Usually 20-30 but we’ve had as many as 110. Usually when the number climbs like that, we strip out unused ones, just makes for more work per box. We use a bulk import process and often bring in 60-80 machines at a time. Is there an upper limit we need to watch for?
-
Try creating a report with the Group being the computer name/number. You can tie multiple sheets to a report. It sounds like you may only need to tie two of the sheets together.
-
With that many computers, the report could get pretty lengthy. Once built, to use it you'll probably want to create a filter that's the computer name/number so you can look at just one computer at a time instead of scrolling to find the computer you want to view applications for.
-
My question was more about building the form with those elements. I don’t expect to be able to see each application when reviewing the computer table. My intent was to select a single computer line and go to a form which shows me everything including all the applications for that PC. I agree that a report without a direct means to filter by Computer would be unwieldy.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!