Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Help with invalid nested IF formula

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

Screenshot 2020-01-10 at 17.18.44

I have two date fields and would like to pull out the months and years in separate fields from one or the other.

I managed to get the single IF working but not the nested function. Here’s my formula:

IF({Date A}, DATETIME_FORMAT({Date A},’YYYY’), IF({Date B}, DATETIME_FORMAT({Date B},’YYYY’)))

which I based on:

IF([logical argument1], [value1], IF([logical argument2], [value2], [value3]))

Any help would be appreciated.

1 Solution

Accepted Solutions

The reason for that is the use of curly apostrophes (’) instead of straight ones (')

See Solution in Thread

2 Replies 2

I copied your formula exactly and it works for me. Is it possible that the {Date A} field in row 2 isn’t truly blank? Perhaps there’s an empty space in it?

image

The reason for that is the use of curly apostrophes (’) instead of straight ones (')