Conditional Cell Linking between a sheet and a form

maheesh.kumar

Hi,

I have created a form in Smartsheets which has different logic, depending on the user's response specific questions appear, and user inputs specific information. This gets created in a sheet in a different set of columns.

Reading this table which is directly being populated from the form can be difficult as one has to scroll left or right due to multiple logic applied in the form. Therefore, I require I fetch the data from the Form's sheet in a different sheet so that I can set it up properly.

For example: In Column 1, if a user response is Standard, it fills out information starting from column 8. Whereas if a user selects Custom option in Column 1, then its information starts from Column 5 and so on.

So is there a way that I can use formula that if column 1 is Standard then fetch data from here, i.e. from a different sheet and specific columns?

Thank you

Andrée Starå

Hi @maheesh.kumar

I hope you're well and safe!

Unfortunately, it's not possible now to use formulas in Forms, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!