What's the best way to get information from 2 sets of users into a single row?

CatSusk

I have a from that collects about 10 fields from people making requests using a form. Then another group will evaluate these requests to ensure all the information is correct. It's currently a second sheet with a form.

I would like to combine it all into one sheet. I know there can't be multiple forms per row. How could I do this?

SteyJ

I have a from that collects about 10 fields from people making requests using a form. Then another group will evaluate these requests to ensure all the information is correct. It's currently a second sheet with a form.<\/p>

I would like to combine it all into one sheet. I know there can't be multiple forms per row. How could I do this?<\/p>","bodyRaw":"[{\"insert\":\"I have a from that collects about 10 fields from people making requests using a form. Then another group will evaluate these requests to ensure all the information is correct. It's currently a second sheet with a form.\\nI would like to combine it all into one sheet. I know there can't be multiple forms per row. How could I do this?\\n\"}]","format":"rich","dateInserted":"2023-08-11T16:14:51+00:00","insertUser":{"userID":159529,"name":"CatSusk","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CatSusk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/14VW8A5MZTQ0\/nJVFDT3V7DJBF.jpg","dateLastActive":"2023-08-15T15:57:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/108860\/whats-the-best-way-to-get-information-from-2-sets-of-users-into-a-single-row","embedType":"quote","name":"What's the best way to get information from 2 sets of users into a single row?"}"> https://community.smartsheet.com/discussion/108860/whats-the-best-way-to-get-information-from-2-sets-of-users-into-a-single-row

Hello@CatSusk!

I recommend using automation to send update requests to the evaluators to review the data and submit their evaluation -- which allows the evaluator to quickly update the row they need to evaluate.

Hope this helps

CatSusk

Thanks for your response. I am using that feature in a slightly different way.

The reason why they they were originally 2 different sheets with forms is the information is very complicated and some users aren't familiar with it. The forms allow for help text and longer field names. For example, "Needs CA PNB pre-review (certification by email from commissioner)".

I'm trying to choose between having these users create a new entry on a different sheet, so that they can use a form, or make a zillion columns with complicated headers in one sheet. How would you make this decision?

SteyJ

Thanks for your response. I am using that feature in a slightly different way. <\/p>

The reason why they they were originally 2 different sheets with forms is the information is very complicated and some users aren't familiar with it. The forms allow for help text and longer field names. For example, "Needs CA PNB pre-review (certification by email from commissioner)".<\/p>

I'm trying to choose between having these users create a new entry on a different sheet, so that they can use a form, or make a zillion columns with complicated headers in one sheet. How would you make this decision?<\/p>","bodyRaw":"[{\"insert\":\"Thanks for your response. I am using that feature in a slightly different way. \\nThe reason why they they were originally 2 different sheets with forms is the information is very complicated and some users aren't familiar with it. The forms allow for help text and longer field names. For example, \\\"Needs CA PNB pre-review (certification by email from commissioner)\\\".\\nI'm trying to choose between having these users create a new entry on a different sheet, so that they can use a form, or make a zillion columns with complicated headers in one sheet. How would you make this decision?\\n\"}]","format":"rich","dateInserted":"2023-08-11T20:21:46+00:00","insertUser":{"userID":159529,"name":"CatSusk","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CatSusk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/14VW8A5MZTQ0\/nJVFDT3V7DJBF.jpg","dateLastActive":"2023-08-15T15:57:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390316#Comment_390316","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/390316#Comment_390316

You’re welcome.

when I have sheets that are complicated, I usually color code areas so users can quickly scroll through and find the data pertaining to them.

I also separate the data into reports so users can just edit from there. for me, it’s just easier to handle bigger sheets that way.

hope this helps!

Andrée Starå

I have a from that collects about 10 fields from people making requests using a form. Then another group will evaluate these requests to ensure all the information is correct. It's currently a second sheet with a form.<\/p>

I would like to combine it all into one sheet. I know there can't be multiple forms per row. How could I do this?<\/p>","bodyRaw":"[{\"insert\":\"I have a from that collects about 10 fields from people making requests using a form. Then another group will evaluate these requests to ensure all the information is correct. It's currently a second sheet with a form.\\nI would like to combine it all into one sheet. I know there can't be multiple forms per row. How could I do this?\\n\"}]","format":"rich","dateInserted":"2023-08-11T16:14:51+00:00","insertUser":{"userID":159529,"name":"CatSusk","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CatSusk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/14VW8A5MZTQ0\/nJVFDT3V7DJBF.jpg","dateLastActive":"2023-08-15T15:57:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/108860\/whats-the-best-way-to-get-information-from-2-sets-of-users-into-a-single-row","embedType":"quote","name":"What's the best way to get information from 2 sets of users into a single row?"}"> https://community.smartsheet.com/discussion/108860/whats-the-best-way-to-get-information-from-2-sets-of-users-into-a-single-row

Hi,

I hope you're well and safe!

To add to SteyJ's excellent advice/answer.

If you have something unique to tie the rows together, we can return the information from the second sheet to the main one.

Do you have something that could be used for it?

You could use the URL-Query feature to code the identifier to the form.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking 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!