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!!
Best answer by Anonymous
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”)
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”)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.