Forum Discussion
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...
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.
