I need a dropdown in my sheet with modifier options for a number. They are in the style of "+2/+1" and "+1/+1/+1" where it could be two numbers or three numbers, separated by a forward-slash and each prepended with a plus.
I can create these as options just fine with no issues, however, upon selecting one Google Sheets will throw an error, "The data that you entered in cell _ violates the data validation rules set on this cell." If I change the invalid option from reject to show a warning, it allows it, thinks the value is an equation, displays the result, and then gives me a warning showing that the value is not within a range which is correct since they're not supposed to be equations.
I've tried using the trick of prepending each option with an apostrophe which does fix them when they're displayed but in the dropdown itself, the apostrophe is visible.
This appears to be a shortcoming of Google Sheets. Is there any way around this at all?