Help

Re: "IF" statement for Dates

Solved
Jump to Solution
503 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Chelsi_Deymonaz
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there! I’m fairly new to formulas and have been playing around with using them in a new base for a client.

I’m wondering if there is any way to create an IF statement or some other formula for if a Date field is empty? Right now if the date field is marked empty, it showcases an error, but I’d like it to still include the other values if left blank. It would be great if it could maybe have TBD" instead.

Any suggestions are greatly appreciated!

Here’s the formula I have so far:

"[" & DATETIME_FORMAT({START / LIVE DATE}, ‘MM/DD’) & "] " & {PROJECT / PROMO NAME} & " " & “[” & SEASON & "]"

Also a screenshot of what I’m trying to do: Screen Shot 2021-02-11 at 11.28.52 AM

1 Solution

Accepted Solutions
Chelsi_Deymonaz
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you all for your assistance! I was finally able to rework this by having a field designated only to the IF statement for the date and have the primary field formula reference that.

See Solution in Thread

4 Replies 4
Airtable_Clerk
6 - Interface Innovator
6 - Interface Innovator

IF({My Date Field}=BLANK(), . . .
Should do it.

Chelsi_Deymonaz
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you! I was able to make that formula work as a stand-alone, but am still having trouble figuring out how it should fit into my existing formula. When I try to embed it into the date portion it works as a formula but still doesn’t act as it should and I’m still receiving errors :confused:

augmented
10 - Mercury
10 - Mercury

See if this works.

“[” & IF({START / LIVE DATE},DATETIME_FORMAT({START / LIVE DATE}, ‘MM/DD’)) & "] " & {PROJECT / PROMO NAME} & " " & “[” & SEASON & “]”

Chelsi_Deymonaz
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you all for your assistance! I was finally able to rework this by having a field designated only to the IF statement for the date and have the primary field formula reference that.