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:
TYIA!
Hello
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
Just checking in to see if you still need help with this?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.