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.
Are the number of hyphens consistent? NotLeft(Right([SAM (2018)],"]"),14)
Thanks for your help. I changed the logging field to same line. This got rid of the dashes, but I am still unable to get it exact so that my data matches in my second field for filters & summaries. I have tried 0, -1, -2. with this formula NotLeft(Right([SAM (2018)],"]"),-2)
See below, all should be one summary line.
Appreciate any additional ideas.