Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

If statement formula help

Topic Labels: Formulas
Solved
Jump to Solution
721 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Solution

Accepted Solutions

I think the formula you want is:

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

See Solution in Thread

4 Replies 4

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

image

I think the formula you want is:

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

Perfect, thank you @Justin_Barrett