Help

Formula for if blank/if not blank

Topic Labels: Formulas
Solved
Jump to Solution
35183 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Emily_Gonzales
5 - Automation Enthusiast
5 - Automation Enthusiast

This closed topic answered my question about accurate time stamps for imported records but i can’t figure out the formula… what is the operator for “not blank”. This is all very new to me and i am learning as i go…

IF({Original Time Stamp}=BLANK(),"{Time Stamp}",IF{Original Time Stamp}=ISNOTBLANK, {Original Time Stamp})

https://community.airtable.com/t/created-date-time-field-and-imported-data/30941

1 Solution

Accepted Solutions

The former is an unformatted date. The latter is formatted. Not sure how you’re seeing both in the same field, but assuming that {Original Time Stamp} is a date, then your formula should become this:

IF({Original Time Stamp}, DATETIME_FORMAT({Original Time Stamp}, "l"), "{Time Stamp}")

A full list of date formatting options can be found here:

See Solution in Thread

3 Replies 3

Welcome to the community, @Emily_Gonzales ! :grinning_face_with_big_eyes:

To check if a field contains anything—i.e. it’s not blank—use this syntax:

IF({Field Name}, ...

To check if a field is empty, wrap the field name in NOT():

IF(NOT({Field Name}), ...

In your case, the formula would become:

IF(NOT({Original Time Stamp}),"{Time Stamp}",IF({Original Time Stamp}, {Original Time Stamp}))

However, this could be greatly simplified:

IF({Original Time Stamp}, {Original Time Stamp}, "{Time Stamp}")

By checking for a non-blank field first, we can use the value found if it’s there, and fall back on “{Time Stamp}” if not.

THANK YOU so much!! this is immensely helpful. Now i have the problem of formatting. I am getting a combination of results that look like this: 2020-06-10T23:43:05.000Z AND this 4/6/2020 5:32pm. I would prefer the latter…

The former is an unformatted date. The latter is formatted. Not sure how you’re seeing both in the same field, but assuming that {Original Time Stamp} is a date, then your formula should become this:

IF({Original Time Stamp}, DATETIME_FORMAT({Original Time Stamp}, "l"), "{Time Stamp}")

A full list of date formatting options can be found here: