Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Finding text between two parenthesis

Tim Steele
edited 12/09/19 in Archived 2017 Posts

I am trying to pull the text between two parenthesis and place in another field.  In the screen shot attached I am wanting to get the data between the two parenthesis in the "Requested by (NetID) field and place it in the "Requested by NetID").  In other words, I want "dj32" to be in the second field.  Anyone have any ideas on the formula.  I've tried a combination of MID, RIGHT, FIND but nothing I put together gets past an error message.







This discussion has been closed.