import and working with an extensive audit questionnaire in Smartsheet

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

😃:

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?

Answers

  • no one who can help ?? 😪

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 03/03/20

    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! 

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!