Calculated column from a multiple lines column

Question

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?

Answer 1

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.

Answer 2

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.