Form Email to only show what was filled out

Bryan Long
Bryan Long ✭✭
in Formulas and Functions

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?

Tags:
· Share on FacebookShare on Twitter

Answers

  • 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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!