Wanting to migrate from outdated software
I'm extremely new to smartsheet, but before I dabble into it further I wanted to ask if it has the capability to do what I need from it.
I work in chemical waste management and our current program for receiving pickups from requestors is very old and stagnant (extremely difficult to make changes to it).
I already created a form and sheet that can ask requestors what they need (put a number for how many gallon bottles they need picked up, if they need a reactive bucket, contact info etc.), but I only want to see what they need and not what they don't. Is there a way to copy over only cells of value, and carry over the title of the column?
For example, if someone requests for just one carboy, I want to have some cells always carry over (like contact information and pickup location), but only have others when there's value, but be able to group the values into pick-up and drop-off in some way.
E.g. | Mary Sue | (123)456-7890 | Pick-up: | 2 Carboys | 1 Reactive Bucket | Drop-off: | 20 Waste labels|
Or something in that fashion... is this possible, and if so, how? Does anyone have a better idea on how to format my sheets so they're more functional for this purpose?
Here is the top portion of the form I created:
And this is a section of the sheet it references.
I want to move/use the first 8 columns for every request, but not have to scroll the entirety of the sheet to the right just to see numerous blank cells that aren't necessary to know for the pick-up. I'd like it in a concise way because I intend to print the sheet with select requests so we can go complete them.
Any help is greatly appreciated!
Best Answer
-
Hey!!
I like to build summary columns to summarize multiple fields in form solutions. I find some of the below functions really useful for that.
Alternatively, you could consider using document builder to build custom PDF's for each row.
Cheers.
Adam
Answers
-
Hey!!
I like to build summary columns to summarize multiple fields in form solutions. I find some of the below functions really useful for that.
Alternatively, you could consider using document builder to build custom PDF's for each row.
Cheers.
Adam
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives