Form Email to only show what was filled out

Lets say I have a form that has 200 questions on it. The person who is filling it out, only answers 50 of those questions and attaches some documents. The email alert that I get automatically shows me all 200 fields and i have to scroll to see which ones they answered vs they didnt. How can I make the email only send what the person filled out?



  • James Keuning
    James Keuning ✭✭✭✭✭

    I think that this is going to be quite difficult for you. Because the fields on a form are columns, and you are asking about a filter, which applies to rows.

    Will you know the person is filling out the form? Can you prep another sheet to receive and process their replies? For example, you add their name to a sheet and paste in 200 rows containing a formula that pivots the columns to rows? I haven't really thought through what the result will look like, but I think the approach will start with a pivot.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!