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?
Add a comment
|
2 Answers
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.
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.
answered May 12, 2020 at 18:00
Ganesh Sanap - MVP
47.4k22 gold badges32 silver badges64 bronze badges
-
Hi @archy321, does this answers your question? If Yes, Please Upvote(^) and accept as an Answer so that it will not be shown under unanswered questions list.Ganesh Sanap - MVP– Ganesh Sanap - MVP2020-05-15 08:55:31 +00:00Commented May 15, 2020 at 8:55