Skip to main content

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

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”)


Reply