Combination sheet info with form
Hi all,
I might have a strange question: is it possible to combine filled out rows in a sheet with collecting information via a form for that row?
For our use case: we are collecting information on open ended coding we perform within our team for other colleagues within the company. See below what we collect: a project number (together with names of the coders), project name, End date for coding, hours spent on coding, verbatims codes, number of verbatims coded per hour.
Now we would like to ask feedback to our colleagues on how we performed on each of the projects. We would like to collect the information using a form. Ideally, the PRJ number and Project name are pre-populated in the form and we just ask them 2 questions:
- score on a scale 1-5
- Any ideas for improvement
So is it possible to combine a row which is filled in in a sheet with a (pre-populated) form for which we ask new info? If yes, how do we do that?
Answers
-
Hi @Jef Snyders
I hope you're well and safe!
- Yes, you'd use the URL-Query feature to have the form pre-populated and then collect it in another so-called helper sheet, which would be connected to the main one using cross-sheet formulas (VLOOKOUP or INDEX/MATCH).
- Another option could be to use the Update Request feature.
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, Awesome, 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.
-
Hi @Andrée Starå ,
Thanks for your quick reply. I think your first option is a bit too complex for my current knowledge. Do you have more info on how to do that?
If not, I just go for your second option.
Jef
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives