IF statement based on two cells

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



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!