AnsweredAssumed Answered

substring-after

Question asked by michael.campbell on Aug 17, 2018
Latest reply on Sep 6, 2018 by michael.campbell

I have a series of Drop Down lists linked to another SharePoint List. The select of the "2. Select Sub-Program" is then required to hide or display other panels. The issue I have is that the actual returned value e.g. 6;#Communication (Stakeholder) is not what is displayed in the list. I tried by using substring BUT becuase the prefix value is comes 1 chr (6;#) and then in other cases "14;#" I cannot return the value I need.

 

Is there any formula similar to substring after that will allow me to return the values after the #/

Example

Outcomes