Consolidating output from multiple forms onto a single line in a sheet
I am quite a new user so apologies if this is quite a simple task
I have a multi stage process which relies upon collecting information from 3 different sources (for which 3 forms have been developed), but as the information all relates to a single request to procure a vehicle, which is being tracked on a single sheet, i want the information from the forms to all fill in along the same row in the sheet
Is this possible?
Thank you 😊
Comments
-
If it works for your process, I’d recommend using a form to initiate the process and then continue with automatic Update Requests.
Would that work?
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 help the Community by marking it as the accepted answer/helpful. 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.
-
Thank you for your help
So, to check my understanding.....
Use the first form, and then continue to use the same form with automatic update requests? I have not tried this before so will read some of the help text and then have a go.
Thank you
Deb 👍️
-
Happy to help!
Yes, but you'll start with the form and then configure the Update Request similar to the form.
Make sense?
Here's more info:
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
-
Thank you - thats really helpful 🤗
-
Now if only we could get Update Requests to mimic the Conditional Logic available in Forms...
-
I agree with @Paul Newcome ! Update Requests are ok for internal staff updates but when reaching outside of the organization to our clients Update Requests are clunky to use. If Update Requests could at least mimic the conditional logic of forms that would be awesome!
-
@Paul Newcome @sdonnelly I've just started creating forms with conditional logic in them and they are great and so easy to build. That is why i originally started out by having a series of forms for my process but then discovered the issue with getting responses on different rows in the sheet 🤔
Im restructuring to see if building as suggestedby Andree delivers what I need
-
Excellent!
You're more than welcome!
To add. Another option could be to keep the forms but have them added to different sheets and then collect them together on one row, and then you can still use the Logic feature, but for it to work, we would need to have something unique to connect them.
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.
-
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.
-
@Andrée Starå - Hi - I have a similar issue. I have a process that I want to follow, and am having some difficulty connecting everything together. I also have a step where I need 3 forms to populate one row item. I'm okay with collecting the forms through different sheets, but how do I consolidate everything onto one row somewhere?
Form 1: Program Owner submits a request by form...Row-ID is assigned to the new request based on the form submitted.
Form 2: I need our Dev team to complete a checklist (in a logical form - the checklist populates based on content type) to ensure they have reviewed all the steps necessary for the request. They can have a question on the form that says enter the Row-ID for this request. (how do I connect this to the original request?) -- Along with this checklist, it moves the content item to QA.
Form 3: I need our QA team to complete a similar checklist (based on that same Row-ID) to ensure they have also checked for requirements, and sign off on QA completion.
And finally, I want all of that to populate to a single line in a sheet to show that content item made it through the workflow.
any suggestions?
-
Hi @TKeller
I’d recommend using an Update Request, if possible, for Form 2 and 3.
Would that work?
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives