Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Nov 27, 2019 08:21 PM
Hello everyone!
Trying to figure out the best way to do perform this formula.
Column Name: Invoice Status
Formula rules within column:
If “payments” column is filled, and “balance” column = zero show “Paid”
If “payments” column is empty, show “Unpaid”
If “payments” column is filled, but “balance” column is greater than zero, show “Partially Paid”
All help is much appreciated!!
Solved! Go to Solution.
Nov 27, 2019 08:26 PM
Actually, I figured it out!!
Here is the formula I used incase anyone else needs something similar!
IF(Payments,IF(Balance > 0,“Partially Paid”,“Paid”),“Not Paid”)
Nov 27, 2019 08:26 PM
Actually, I figured it out!!
Here is the formula I used incase anyone else needs something similar!
IF(Payments,IF(Balance > 0,“Partially Paid”,“Paid”),“Not Paid”)