
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 05, 2020 11:54 AM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 05, 2020 11:58 AM
IF( {genres 1}, {genres 1}, {genres 2} )
translation: IF( genre 1 is defined, return genre 1, otherwise return genre 2 )

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 05, 2020 11:58 AM
IF( {genres 1}, {genres 1}, {genres 2} )
translation: IF( genre 1 is defined, return genre 1, otherwise return genre 2 )
