Calculated column with IF condition

Question

I'm writing from Italy. I have a list of 5 columns: one of them is called "available" and it's a yes/no column.

Another column is a text column called "last name". I want to create a calculated column which takes last name ONLY if "available=yes" otherwise it should leave the field empty.

I tried =IF([Available]="Yes","[Last Name]","") but it doesn't work.

"syntax error" is the answer. What's wrong according to you?

Answer 1

As [Available] is a Yes/No (Boolean) column, use formula like:

=IF([Available],[Last Name],"")

Output:

---

Note:

1. Sometimes comma(,) does not work in formula (It is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
2. Make sure you are using correct display name of columns in your formula (case sensitive).