3 Clarified my question and provided a picture to help illustrate what I am trying to explain.
source | link

I have Google Sheets running the add-on formmule to automatically send emails with the responses to a Google Form. Using the following formula, I was able to get a nice HTML table to show up in the body of each email.

=RANGETOTABLE(FILTER(D:AH,A:A=A2),$D$1:$AH$1)

This createsreturns a custom HTML table based on the data in each cell. However, not every cell will have a response.that looks like this:

Blank cells and a single response cell

I was hopingwant to trim the fat on my tabletry and get rid of all the blank responses. Can I nest an additional filter conditionthe cells with nothing in there to dothem, out, so that? only cells with values in them are returned.

I have Google Sheets running the add-on formmule to automatically send emails with the responses to a Google Form. Using the following formula, I was able to get a nice HTML table to show up in the body of each email.

=RANGETOTABLE(FILTER(D:AH,A:A=A2),$D$1:$AH$1)

This creates a custom HTML table based on the data in each cell. However, not every cell will have a response. I was hoping to trim the fat on my table and get rid of all the blank responses. Can I nest an additional filter condition in there to do that?

I have Google Sheets running the add-on formmule to automatically send emails with the responses to a Google Form. Using the following formula, I was able to get a nice HTML table to show up in the body of each email.

=RANGETOTABLE(FILTER(D:AH,A:A=A2),$D$1:$AH$1)

This returns a table that looks like this:

Blank cells and a single response cell

I want to try and filter the cells with nothing in them, out, so that only cells with values in them are returned.

2 deleted 99 characters in body; edited tags
source | link

I have Google Sheets running the add-on formmule to automatically send emails with the responses to a Google Form. Using the following formula, I was able to get a nice HTML table to show up in the body of each email.

"=RANGETOTABLE(FILTER(D:AH,A:A=A2),$D$1:$AH$1)"

=RANGETOTABLE(FILTER(D:AH,A:A=A2),$D$1:$AH$1)

This creates a custom HTML table based on the data in each cell. However, not every cell will have a response. I was hoping to trim the fat on my table and get rid of all the blank responses. Can I nest an additional filter condition in there to do that? I am completely unfamiliar with the filter formula so I apologize if this is a really basic question.

I have Google Sheets running the add-on formmule to automatically send emails with the responses to a Google Form. Using the following formula, I was able to get a nice HTML table to show up in the body of each email.

"=RANGETOTABLE(FILTER(D:AH,A:A=A2),$D$1:$AH$1)"

This creates a custom HTML table based on the data in each cell. However, not every cell will have a response. I was hoping to trim the fat on my table and get rid of all the blank responses. Can I nest an additional filter condition in there to do that? I am completely unfamiliar with the filter formula so I apologize if this is a really basic question.

I have Google Sheets running the add-on formmule to automatically send emails with the responses to a Google Form. Using the following formula, I was able to get a nice HTML table to show up in the body of each email.

=RANGETOTABLE(FILTER(D:AH,A:A=A2),$D$1:$AH$1)

This creates a custom HTML table based on the data in each cell. However, not every cell will have a response. I was hoping to trim the fat on my table and get rid of all the blank responses. Can I nest an additional filter condition in there to do that?

1
source | link

How do I modify this Google formula to filter out blank responses from Google Sheets?

I have Google Sheets running the add-on formmule to automatically send emails with the responses to a Google Form. Using the following formula, I was able to get a nice HTML table to show up in the body of each email.

"=RANGETOTABLE(FILTER(D:AH,A:A=A2),$D$1:$AH$1)"

This creates a custom HTML table based on the data in each cell. However, not every cell will have a response. I was hoping to trim the fat on my table and get rid of all the blank responses. Can I nest an additional filter condition in there to do that? I am completely unfamiliar with the filter formula so I apologize if this is a really basic question.