Ok i guess i'm doing formula wrong.
I have a choice column "Single"with two choices that i typed "Yes" and "No".
The second column "Album" is the calculated one and it's supposed to work like this:
If the "Single" is yes , then "Album" shows No If the "Single" is no, then "Album" shows yes
What IF formula should i put into "Album" formula field?
If i try with True/False i always get only one answer doesn't matter what the "Single" shows.