have gone back to work on an app i havent touched since early 2020 and noticed that this formula:
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CONCATENATE(RIGHT([client],4),NOW()),"/",""),":","")," “,”") is doing something odd when saving to the google sheet. it is producing an extra character, an apostrophe at the beginning of the string. It did not do this before and i was wondering if something had changed.
when I look at the google sheet i don’t see the apostrophe until I click in the cell and look at the formula bar. '639602242021161947.