Help

Taking totals from a different table depending on status

602 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Paul_McFarlane
4 - Data Explorer
4 - Data Explorer

I am using Airtables to hold a table of my customers and their credit limits etc and keep a tally of invoices sent and their payment status.

I was wondering…
Next to where the customers credit limit is, I would like a column that shows their current credit usage.

IE.
IF invoices table,column.invoicespaid = no then sum amount where invoices table,column.cutmoner name = thistable.accountname

Is this possible?

Hopefully you understand my attempt at an example formula

0 Replies 0