1

It seems that sharepoint does not allow MM columns to be used in calculated fields, and I'm not sure how to use them in a workflow either. Can someone please inform me as to how I can use terms in the MM columns to serve as workflow and calc. field conditions?

3

Nice example by our Marc D Anderson that covers both aspects of your question:

Displaying Managed Metadata Column Values in an Email Sent from a SharePoint Designer Workflow

If you have MM column called ColumnA you can use text portion of it in calculated field with formula:

=LEFT([ColumnA],FIND(“|”,[ColumnA])-1) 
  • How to you do if your column has multiple managed metadata values ? – barbuslex Mar 4 '15 at 17:01
  • Watch out if you copy and paste... “” needs changing to "" – Nullldata Dec 22 '16 at 10:43
  • How can it work if Calculated column do not work the MM column?! – Marpio Mar 28 '17 at 7:07

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.