IF statement based on two cells

Mary Smith

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

Paul Newcome

Based on the formula I provided, it should not show "WAIT" if there is a date. Is the [Actual Invoice Date] column a date type or a text/number type?

Paul Newcome

Try this...

=IF([PAID?]@row = 1, "PAID", IF(ISDATE([Actual Invoice Date]@row), "SENT", "WAIT"))

Morgan Marquez

Hi there! Try this:

=IF([Paid]@row = 1, "PAID", IF([Actual Invoice Date]@row>0, "Sent", "Wait")

Mary Smith

Hi Paul, Thanks for the input. It almost works. It changes to PAID when the box is checked, but it displays WAIT when there is a date is present. I'd like to display SENT.

@Morgan Marquez unfortunately that didn't work. I get the UNPARSEABLE error.

Thank you both!

Paul Newcome

Based on the formula I provided, it should not show "WAIT" if there is a date. Is the [Actual Invoice Date] column a date type or a text/number type?

Mary Smith

@Paul Newcome , with the Date type it works! My mistake.

Thanks for this! Have a great day.

Paul Newcome

Happy to help! 👍️