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