Automation - customizing the response layout
I have set up a test sheet which has the automation: when APPROVED = YES then notify Named Person (See below)
When that person receives the email, they get a grid of the entries in column format (see below)
Is there a way to stack the responses as opposed to seeing the whole grid as my live data has around 40 columns which would be too large to see horizontally but if they could be stacked (see example below) the scrolling and space save would be much better and more likely to get a response
Question 1 - Was there any water available - YES
Question 2 - Was there any food available? - YES
Question 3 - Were there any tables available? - NO
Instead of seeing it in a grid
Q1. Was there any water available Q2. Was there any food available? Q3. Were there any tables available?
1 YES YES NO
Help Article Resources
Check out the Formula Handbook template!