Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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.

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.

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! 🙂

Reply


Terms & Conditions