1

enter image description hereI'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?

Improve this question
2
  • Just want to confirm - Is it a yes/no (boolean) column or choice column with Yes and No choices?
    – Ganesh Sanap
    Feb 28 at 10:22
  • it's a boolean column
    – fabio
    Feb 28 at 10:53

1 Answer 1

Reset to default
0

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

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

Output:

enter image description here

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).
Improve this answer
13
  • For choice column with Yes and No choices, you have to use: =IF([Available]="Yes",[Last Name],"")
    – Ganesh Sanap
    Feb 28 at 10:23
  • I tried but it still doesn't work "Syntax error or not supported".i even tried =SE and ; (due i'm from italy) but it's not working.may be they should be activated somewhere ???
    – fabio
    Feb 28 at 10:31
  • Can you attach screenshot of calculated column settings you are using while creating a column?
    – Ganesh Sanap
    Feb 28 at 12:09
  • done in the main post
    – fabio
    Feb 28 at 12:50
  • 1
    i tried with your suggestions with " =IF(REPERIBILE;NOMINATIVO;"") " and now it works.THANKSSSSSSS
    – fabio
    Mar 1 at 10:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.