Timeline for Calculated column with IF condition
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 1, 2023 at 10:47 | comment | added | Ganesh Sanap - MVP | Great, glad it worked for you! | |
| Mar 1, 2023 at 10:41 | vote | accept | fabio | ||
| Mar 1, 2023 at 10:40 | comment | added | fabio | i tried with your suggestions with " =IF(REPERIBILE;NOMINATIVO;"") " and now it works.THANKSSSSSSS | |
| Mar 1, 2023 at 8:56 | comment | added | Ganesh Sanap - MVP | It works for me (see above screenshot). Can you try same in another SharePoint site in same tenant OR another tenant? If still doesn't work, raise support ticket with Microsoft: learn.microsoft.com/en-us/microsoft-365/admin/… | |
| Mar 1, 2023 at 8:55 | history | edited | Ganesh Sanap - MVP | CC BY-SA 4.0 |
added 106 characters in body
|
| Mar 1, 2023 at 8:49 | comment | added | fabio | thanks anyway for your help | |
| Mar 1, 2023 at 8:48 | comment | added | fabio | nothing works.perhaps formula should be activated somewhere ? | |
| Mar 1, 2023 at 8:38 | comment | added | Ganesh Sanap - MVP |
Correction in above comment, in case of Yes/No column you have to use: =IF([Available],[Last Name],"")
|
|
| Mar 1, 2023 at 8:23 | comment | added | fabio | i switched the site language in english,but it still doesn't work.i'm going mad | |
| Mar 1, 2023 at 5:48 | comment | added | Ganesh Sanap - MVP |
Not sure about language of your site. Can you create similar list in site with English language and check if this formula works: =IF([Available]="Yes",[Last Name],"")
|
|
| Feb 28, 2023 at 18:30 | comment | added | fabio | tks for any help | |
| Feb 28, 2023 at 12:50 | comment | added | fabio | done in the main post | |
| Feb 28, 2023 at 12:09 | comment | added | Ganesh Sanap - MVP | Can you attach screenshot of calculated column settings you are using while creating a column? | |
| Feb 28, 2023 at 10:31 | comment | added | fabio | 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 ??? | |
| Feb 28, 2023 at 10:23 | comment | added | Ganesh Sanap - MVP |
For choice column with Yes and No choices, you have to use: =IF([Available]="Yes",[Last Name],"")
|
|
| Feb 28, 2023 at 10:19 | history | answered | Ganesh Sanap - MVP | CC BY-SA 4.0 |