I’m looking to replicate a formula from Google Sheets in AirTable.
I have two tabs on a spreadsheet. One tab is a list of Editors (screenshot above) with the name of the editor in column A, an the amount owed in column B. The second tab is Customer Orders, which tracks each order, the editor assigned to the order, and the amount owed for completion of the order.
I’m trying to replicate the functionality such that the Editor tab sums up the amount owed for each editor. As I mark each payment on the Customer Orders tab complete with a “Y”, it is no longer counted toward the amount owed.
I’m having difficulty getting this functionality to work in AirTable. Thank you for your help!