I have a button that adds a row to another sheet. One of the fields sets to a constant of “1”(numeric one). I have the precision of that column set to “1”
The value in the cell of the destination sheet is " '1 " (preceding single quote). The FILTER formula that addresses this value then fails becasue the value is not numeric. Column is formatted to numeric precision o.
I had the same problem with Time Only fields but thought that was just peculiar to time fields. I wrote a function in app scripts to reformat on Edit to fix that. But it seems this problem is deeper.
Any views?