Hi there,
Having some problems nesting two IF statements. Here’s what I’d like to happen:
IF date is present in Actual Invoice Date column, then display “SENT” in Invoice Status column.
IF the checkbox the in PAID? Column is checked, then display “PAID” in the Invoice Status column.
IF there is no date present in the Actual Invoice column, then display "WAIT” in the Invoice Status column,.
These two formulas work independently , just don’t know what o companies them so the priority mentioned above takes place.
=IF(ISBLANK([Actual Invoice Date]39), "wait", "sent")
=IF([PAID?]@row = 1, "PAID")
Thanks!
Mary
