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?

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

1 Answer 1

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).
13
  • For choice column with Yes and No choices, you have to use: =IF([Available]="Yes",[Last Name],"") Feb 28, 2023 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, 2023 at 10:31
  • Can you attach screenshot of calculated column settings you are using while creating a column? Feb 28, 2023 at 12:09
  • done in the main post
    – fabio
    Feb 28, 2023 at 12:50
  • 1
    i tried with your suggestions with " =IF(REPERIBILE;NOMINATIVO;"") " and now it works.THANKSSSSSSS
    – fabio
    Mar 1, 2023 at 10:40

Your Answer

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

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