1

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.

=IF(ISERROR(FIND("flight",[shipping])),"ground","flight")

What am I doing wrong?

0

As Ganesh said, Multiple Lines of Text columns are not supported in Calculated columns.

You can create SharePoint designer workflow to achieve you requirement, using if condition and set a field to value in the current list action.

| improve this answer | |
0

This is a known behavior. Calculated columns does not allow Multiple Lines of Text columns to be used in their formulas.

Reference: SharePoint 2013 Make Calculated Column based on Custom Column

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.