I have a SharePoint list (Issue Tracker), here I created a calculated column like Product Name and the formula is:


And, My requirement is when the user wants to add an issue based on the title then, the issue will appear under the Product name. But, whenever I have added one condition it will work but adding another condition then it will give an error.

enter image description here

Suggest any solution.

  • So according your requestion will always first word of the Title be product name? e.g. Product1 issue, Product2 issue ? and you want to store first word in the Product Name column> Commented Jul 24, 2023 at 11:26
  • @GaneshM, does my below answer help you in any way? Commented Jul 25, 2023 at 11:25

1 Answer 1


Try using this formula for your calculated column:



enter image description here


  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].

Official Documentations:

  1. Calculated Field Formulas
  • Thank you so much, sir
    – Ganesh M
    Commented Jul 24, 2023 at 12:57
  • You're welcome! Glad it helped you. Keep using this platform to ask any questions related to SharePoint. Commented Jul 24, 2023 at 13:16
  • Hi @GaneshM, Please Upvote(^) and accept my response as an Answer as it helped you & it will help others with similar question in future to find the correct answer easily. It also removes this question from "Unanswered questions" list. Commented Nov 9, 2023 at 12:54

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.