Filter out blank responses in columns using formsmule stackoverflow

Recent Questions - Web Applications Stack Exchange

I currently have a response form where people are submitting requests for different items. Not every item is requested every time. The end goal is to automatically have them receive an email with a list of each item they requested after submitting the form.

Using =rangetoverticaltable with formsmule you get a pretty table as below

enter image description here

The end goal is to get the same table returned but with the "water" column being filtered out as it is blank. IE

enter image description here

Ive read this post multiple times and I cant seem to figure out if the answer at the end of the post closes with it isn't possible or i'm missing a step.

The link to the google sheet is below https://docs.google.com/spreadsheets/d/10jXvND6MLaPWk1kwzWiBOWZk9eNghpAEgOK5JvKWy00/edit#gid=1961786966

Any ideas?


Recent Questions - Web Applications Stack Exchange Recent Questions - Web Applications Stack Exchange by Medicgeek via Recent Questions - Web Applications Stack Exchange

No comments:

Post a Comment