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