I’ve got a small error and not sure if it’s a bug or not.
I have an “If statement” where if a code matches another code then do something, it works on pretty much every code in the column apart from this one: 2810-103 or any code like: 1234-123
I’ve figured out that any 4 digit code hyphen 3 digit code won’t work.
Now, If I go to the cell and copy another code and paste it into a formula it pastes the code, If i copy the code above it pastes the following: EpochToDate(26531625600).
I’ve tried everything and even typing the code into the formula manually won’t work, although the code in the formula is correct, it won’t.
Here’s a sample doc.