• Lizaveta Melnikava
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

I am trying to do more than one substitution in a field update formula and am having difficulty getting it correct.   This is what I have:

 

OR(Contains(Name ,'Duplicate -'), SUBSTITUTE(Name,"Duplicate -"),

     (Contains(Name ,' - Duplicate'), SUBSTITUTE(Name," - Duplicate"),"")))

 

All help is greatly appreciated.

 

Thanks