Help

If statement formula help

Topic Labels: Formulas
Solved
Jump to Solution
1450 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Holli
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Justin_Barrett
18 - Pluto
18 - Pluto

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
Steve_Vo
6 - Interface Innovator
6 - Interface Innovator

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

Holli
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Justin_Barrett
18 - Pluto
18 - Pluto

I think the formula you want is:

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

Perfect, thank you @Justin_Barrett