import and working with an extensive audit questionnaire in Smartsheet

Joerg Schmidt

Hi together,

we want to import an extensive questionnaire based on an excel sheet and set the questions to

At the moment it looks like the attached example

template.png

😃:

question 1 / note / percentage / notes

question 2

question 3

if we use the form in Smartsheet it will only show the headings, not the questions

how can we rotate the excel sheet when importing it into Smartsheet? Otherwise, we would have to

create the sheet with its over 300 questions new ;-((

Anyone an idea?

Joerg Schmidt

no one who can help ?? 😪

Andrée Starå

Hi Jörg,

I’d recommend either to transpose the excel sheet or/and copy/paste so that it makes sense when importing to Smartsheet.

To show the questions, you would either need to add them as text to the form or as columns that you’d include in the form.

Make sense?

Another option could be to use a third-party integration like Google Forms or similar.

Would any of those methods work/help?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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!