Design Help
This is a very generalized question as I am having a hard time redesigning my workplaces sheets.
Currently we have our main sheet "Bid List" It is a rather informative sheet that has everything we could need on it and in there lies the problem in that EVERYTHING is on it. It has 50 some columns, thousands of rows and is just a mess to the point I can't design any kind of reporting or helper sheets to report from based off it since the data is all over the place and a given projects info can be spread over as many as 20 additional rows with the main parent row having such generalized info that I cannot connect the dots.
Per the picture above, you can see more or less how they have initially built it. the problem becomes that all data regarding numbers for bids and such is stored on the parent line and I have not been able to figure out a way to relate the child rows to the parent line. What makes matters worse is if each contractor has a specialized quote, the numbers are put on the parent line, and different numbers are put on the child rows.
How can I break this up for reporting, but keep it more or less together for internal info? I tend to think in the lines of how MS Access works, so I am struggling with this.
Answers
-
I hope you're well and safe!
Not sure I follow.
You could reference the Parent row(s) to the Children's row(s).
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That would work if I could relate say Gutridge Plumbing to the parent rows column say 15. That would allow me to relate a bid number to that contractor.
-
Excellent!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives