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

BDuplain

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!

Kleerfyre

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.

Kleerfyre

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.

BDuplain

Thank you, @Kleerfyre! That worked perfectly:)

Kleerfyre

Glad I could help!

Mary Beth B.

@Kleerfyre Is there a way to actually do it in the sheet and not a form?

Kleerfyre

Smartsheet doesn't dynamically hide or show columns based on cell entries.