Skip to main content
Best answer

Zapier Tables: How to calculate change

  • October 21, 2024
  • 3 replies
  • 19 views

I would like to tabulate the change in values in a column. I have a column of balances with today’s balance. I would like to have a field that calculates the change in today’s balance from yesterday’s balance (i.e. the value in the row above). It is not clear to me how to do any calculated fields, but especially not this one.

Best answer by SamBBest answer by SamB

Just circling back in here to add that we’ve recently added Formula fields to Zapier Tables which could be used to calculate the difference between values in different columns! 😁🎉

You can learn more about this exciting new feature here:

Happy Zapping! ⚡

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2188 replies
  • October 22, 2024

Hi @syndic8er,

 

Welcome to the Community.

 

We sincerely apologize, but Zapier Tables can't support calculated fields or operations that subtract one row's value from another. However, a workaround is to perform the calculation externally, such as in Google Sheets or Excel, and then import the results into Zapier Tables. This involves creating a new column in Google Sheets for the balance change, using built-in functions to calculate the change, copying the formula down the column, and importing the results into Zapier Tables by setting up a Zap to trigger when a new row is added to your Google Sheet. Despite not being the ideal solution, this workaround helps navigate the limitations of Zapier Tables.

 

We hope that this workaround will be practical and cater to your needs.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7289 replies
  • October 28, 2024

Hi @syndic8er 👋

Did Jammer’s suggestion work for your needs here? 

If not, I’d recommend watching this video guide for details on an alternative workaround that doesn’t require the use of Google Sheets:


Hope that helps. If you run into any issues on that or have any further questions at all just let us know - happy to assist further! 🙂


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7289 replies
  • Answer
  • February 7, 2025

Just circling back in here to add that we’ve recently added Formula fields to Zapier Tables which could be used to calculate the difference between values in different columns! 😁🎉

You can learn more about this exciting new feature here:

Happy Zapping! ⚡