Skip to main content
Question

Issues with using SUMIFS in Zapier Tables and how to solve them


I ran into a few issues in using Zapier Tables

1, I know that it can't do sumifs like excel or sheets and I have to do it through codes

2. When I do this, it kept on returning zero - my question is how does the code read a column? Like how does it identify it "Column 2 or Column B or it uses the column name?"

3. I need to then transfer the result to another table

Did this topic help you find an answer to your question?

3 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@Equi 

To help us have more info, post screenshots about what you are referring to related to the Code and Zapier Table.


  • Author
  • Beginner
  • 1 reply
  • March 26, 2025

it does everything successfully in the test but the data output is blank

 


Troy Tessalone
Forum|alt.badge.img+14

@Equi 

The screenshot of the Code step shows an input variable from Zap step 1 that is an ISO datetime.

It does not show the output values that are generated.

 

The screenshots of Zap step 3 does not show how it is configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.

 


Reply