Solved

If statement formula help

+5

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.

Best answer by Justin_Barrett

I think the formula you want is:

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

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

+5

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

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

+21

I think the formula you want is:

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

+5

I think the formula you want is:

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

Perfect, thank you @Justin_Barrett

Sign up