If statement formula help

[Holli]

Trying to set 1st field as a formula with IF statement.

I currently have:

Bill & " - " & DATETIME_FORMAT({Due Date}, “ll”)

I have another table for bills paid on irregular date (non due date). Without the Due Date being filled in I get an Error in the formula.

I’d like to have the formula show IF Due Date Empty, date paid

Thank you.

[Steve_Vo]

If({Due Date}="",{Date Paid})

[Holli]

Thanks @Steve_Vo, I am getting an error message when I add this formula to my current one. Suggestions?

Bill & " - " & DATETIME_FORMAT({Due Date}, “ll”), IF({Due Date}="",{Date Paid})

[Justin_Barrett · Accepted solution]

I think the formula you want is:

Bill & " - " & DATETIME_FORMAT(IF({Due Date}, {Due Date}, {Date Paid}), "ll")

[Holli]

Justin_Barrett:

Bill & " - " & DATETIME_FORMAT(IF({Due Date}, {Due Date}, {Date Paid}), “ll”)

Perfect, thank you @Justin_Barrett