I made this formula for a calculated column that works from with single line columns, but am unable to make it work with a multiple line column.
What am I doing wrong?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
This is a known behavior. Calculated columns does not allow Multiple Lines of Text columns to be used in their formulas.
Workaround: You can create a Microsoft Flow/Power Automate or SharePoint designer workflow to check the substring in your multiple lines of text field and set the custom field value accordingly.