Forum Discussion

jonengland's avatar
jonengland
Copper Contributor
Nov 20, 2023

Sharepoint Calculated Column using IF and Concatenate

I have a SharePoint table which is populated from a Form. I'd like to complete a record in a column based on responses elsewhere in the form. I've successfully created an IF statement based on what's been selected:

 

 

 

=IF(Item="Laptop","L",IF(Item="Desktop","D",IF(Item="Server","S",IF(Item="Printer","P",IF(Item="iPhone","iPh",IF(Item="iPad","iPD",IF(Item="Android","And",)))))))

 

 

 

I'd like to append in the same column to the output of the above further IF statements, relating to Location (Working from Home, Office Based etc), then Operating System (Windows, MacOS, Linux, iOS). For context this is to automatically create a device ID for inventory logging based on a Form.

 

Thanks in advance.

Forms
SharePoint Server
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Nov 21, 2023

    jonengland You can achieve it using SharePoint calculated formula.

     

    Here is an example you can follow for your requirements: 

     

    =IF([Item]="Laptop","L",IF([Item]="Desktop","D","")) & "-" & IF([Location]="India","IND",IF([Location]="Australia","AUS","")) & "-" & IF([Operating System]="Windows","Win",IF([Operating System]="MacOS","Mac",""))

    It will give you results like L-IND-Win (example).

     

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources