If one of four answers given in column1, different columns populate as follow-up questions

BDuplain
BDuplain ✭✭✭
edited 06/01/23 in Formulas and Functions

Question in column1 has four possible answers. Depending on which of the four answers are provided, I would like to provide column2, column3, column4, or column5 as follow up questions. Is there a formula or automation to do this? Thanks!

Best Answer

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Answer ✓

    The easiest way to do this is via a form. You have conditional logic within the form that can show what you want based on how the person answers the base question.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!