I agree that this is a problem, @sneike. See Apostrophe in front of each answer in formula bar causing problems with formulas in other sheets - #2 by LN for more context and a suggested approach for now.
I agree that this is a problem, @sneike. See Apostrophe in front of each answer in formula bar causing problems with formulas in other sheets - #2 by LN for more context and a suggested approach for now.