I have a multiple choice field tracking changes "SAM (2018)". I added a second field "SAM (2018)* to act as a clean field for reporting and used this formula: NotLeft(Right([SAM (2018)],"]"),0)
The formula is not pulling in just the name, it is also pulling in the separation lines. See image below. I have tried to adjust the formula without success. Not sure where I am going wrong. I only want it to pull "Unassigned" not the --------------. Any help would be appreciated.