If Question

Samuel Dowdy Jr.

=IF([PO Status]@row = "Approved", [Purchase Order No.]@row),IF([Multiple Invoices]@row="true",""

What am I doing wrong?

Samuel Dowdy Jr.

I basically have a auto number for the PO column that is hidden, if the po is approved then the PO (by Office) is filled to match the auto number. But, if the po has multiple invoices when it comes in I dont want the new line to generate a PO number.

Dale Murphy

@Samuel Dowdy Jr. Other than bracket management, it looks okay. What result are you getting?

Try this (it works in North America):

=IF([PO Status]@row = "Approved", [Purchase Order No.]@row, IF([Multiple Invoices]@row="true",""))

Just beware that the formula evaluates the "Approved" state first. So it will ignore the "Multiple Invoices" flag if PO Status == Approved.

dm

Jeff Reisman

I think you'll want to add the AND function into your IF:

=IF(AND([Multiple Invoices]@row= "false", [PO Status]@row = "Approved"), [Purchase Order No.]@row, "")

The AND function tells the formula to evaluate both criteria first, and they both have to be true to set the value. So if Multiple Invoices is unchecked, and PO Status is approved, set the value to the [Purchase Order No.]@row, otherwise, leave it blank.

Note: Be sure to close out your AND statement with an end parentheses, before going on to your true condition. In the above, it's right after "Approved".