Google Sheet Re-format, Dropping Columns without values for specific rows

  • 29 November 2020
  • 2 replies

Userlevel 1

Looking for some help with Google Sheets Formatting!


My end goal is to take information from a specific row to create a new google doc from a template.


Here are a few sample rows-


Here’s what the doc template looks like-


I only want an item (i.e. the column header food iteam) to show up if the quantity is greater than 0.


Is there a way to use zapier formater or conditions to create an intermediate sheet/tab?


This is what my Zap is looking like so far:



This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 2

Hello @Easy Eats can you provide more information regarding the items (item 1 2 3..) is item 1 : scrambled eggs, item 2 :  sausage patty .. etc


So for the qty you wanna get the addition of each row so for the qty for scrambled eggs you wanna get (1+4+1+6= 12) ? is that right ? 

and you only want for a row to be created if item has at leat 1 in qty ? so for example if sausage patty didn’t have 1+1 in qty but instead it had 0 it should show on the doc is that correct ? 


thanks for taking time to make It easier for me to understand your need 

Userlevel 7
Badge +10

@Easy Eats 
Just checking in to see if you still need help with this?