I have imported a column of Data from Excell, I need it to remain while data is imported from form

Alison Jones · 05/20/24

Paul McGuinness · 05/21/24

Hi @Alison Jones

Any new form entries added to the sheet will be added as new rows beyond what you have imported from excel.

Hope that helps

Thanks

Paul

Paul Newcome · 05/21/24

Are you able to provide screenshots and more details as to the actual flow of data?

Andrée Starå · 05/21/24

https://community.smartsheet.com/discussion/122184/i-have-imported-a-column-of-data-from-excell-i-need-it-to-remain-while-data-is-imported-from-form

Hi,

I hope you're well and safe!

Not sure I follow!

Can you elaborate and share some screenshots? (Please delete/replace any confidential/sensitive information before sharing.) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅ Did my comment help or answer your question? Please support the Community and me by marking it
💡 ⬆️ ❤️ or/and as the accepted answer. It will make it easier to find a solution! Thanks!

Alison Jones · 05/22/24

The coupon code column data has been prepopulated by uploading from excell. The following columns are populated via a client completing the attached form - as you can see the form answers are pushing down the prepopulated column. Is there a way I can link this column with the data coming in from the form - so a cupon code is auto attached to each row?

Andrée Starå · 05/22/24

https://community.smartsheet.com/discussion/comment/437183#Comment_437183

Does the coupon code have to match a specific form submission, or can it be random?

Workaround(s)

Have a another sheet to either have the form collected or have the coupon codes and then use INDEX to match for each row, or add some helper columns and use INDEX/MATCH.
Use Update requests instead.

Make sense?

Would any of those options work/help?

✅ Remember! Did my comment help or answer your question? Please support the Community and me by marking it 💡 ⬆️ ❤️ or/and as the accepted answer. It will make it easier to find a solution! Thanks!

Paul Newcome · 05/22/24

@Alison Jones How exactly are the users indicating which coupon code they are wanting to fill the form out for?

Alison Jones · 05/23/24

he coupon code canbe randomly selected from the list, however each code is unique and can only be used once

Andrée Starå · 05/23/24

https://community.smartsheet.com/discussion/comment/437406#Comment_437406

Ok.

I think one of my proposed solutions would work.

What do you think, and which one do you prefer?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Paul Newcome · 05/23/24

In that case, I would suggest using a second sheet to capture the form entries and then using a series of INDEX/MATCH formulas to bring the data back over to your import sheet.

=INDEX({Form Sheet Coach Name Column}, MATCH([Coupon Codes]@row, {Form Sheet Coupon Code Column}, 0))

I have imported a column of Data from Excell, I need it to remain while data is imported from form

Answers

Categories