1

I'm trying to create a calculated column based on a status column. The status column is a multi choice column (but I can change in a text column).

For example: if the status is "xxxx", I'd like it to return a number

=IF([Status]="Engine on", "40", IF([Status]="Functional check", "50", IF([Status]="Assembly", "80", "0")))

I tried this code but I have an error message on Lists when I confirm it.

Improve this question
1

1 Answer 1

Reset to default
1

Multiple selection choice columns in SharePoint list are not supported in calculated column formulas.

If you use single selection choice column or text column, you can use calculated column formula like:

=IF([Status]="Engine on", 40, IF([Status]="Functional check", 50, IF([Status]="Assembly", 80, 0)))

Calculated column settings:

enter image description here

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. Use correct display name of your SharePoint columns in above formula.
  3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name].
Improve this answer
5
  • Thanks a lot!!!! The problem was the , instead of ; !!!! Could I ask another thing? If I would say IF the column has the status A or the status B write the same number, how can I say? In this way I will not use the 7 "slot" of IF cicle
    – Massimo Borrelli
    Commented Jun 17 at 10:02
  • For your above query, you can use formula like: =IF(OR([Status]="A";[Status]="B");80;0). Let me know if this works for you.
    – Ganesh Sanap - MVP
    Commented Jun 17 at 10:15
  • It works! Thanks a lot!!!! One more thing: I tried also with "Multiple selection choice columns" and it works also in this case!!!!
    – Massimo Borrelli
    Commented Jun 17 at 12:01
  • You are welcome, I am glad it worked for you!
    – Ganesh Sanap - MVP
    Commented Jun 17 at 13:04
  • Can you please accept it as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily. Thanks!
    – Ganesh Sanap - MVP
    Commented Jun 17 at 13:04

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.