Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula if for empty values

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

Hi
I have one column called genres 1 and another column called genres 2
I want to add another column that returns me the value of genre 1 when it isn’t blank and returns me the column genre 2 when the column genre 1 is blank
I know I have to use the If function, but I dont know how to apply to this case
Can you provide me some help?
Thanks in advance!

1 Solution

Accepted Solutions

IF( {genres 1}, {genres 1}, {genres 2} )

translation: IF( genre 1 is defined, return genre 1, otherwise return genre 2 )

See Solution in Thread

1 Reply 1

IF( {genres 1}, {genres 1}, {genres 2} )

translation: IF( genre 1 is defined, return genre 1, otherwise return genre 2 )