Combination sheet info with form

Jef Snyders

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?

Andrée Starå

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!

Jef Snyders

https://community.smartsheet.com/discussion/comment/404843#Comment_404843

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