Help

Help with invalid nested IF formula

Topic Labels: Formulas
Solved
Jump to Solution
1825 2
cancel
Showing results for 
Search instead for 
Did you mean: 
valushk
4 - Data Explorer
4 - Data Explorer

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
Kamille_Parks
16 - Uranus
16 - Uranus

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

Kamille_Parks
16 - Uranus
16 - Uranus

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