Hi there,
I usually use Timestamp as Key and setup reference between tables. However, once in a while I would see that even the timestamp is copied and referenced from one sheet to another, when it gets uploaded to google sheet, there would be some issue with the key being not exactly the same.
For example:
On Google Sheet, I would set the column format as Date Time, and it would show as the same for the 2 rows below (The time is displayed in chinese, where 年 = Year, 月 = Month, 日 = Date):
2020年2月19日 下午02:57:08
2020年2月19日 下午02:57:08
(Note that the above 2 dates are the same)
When I change the format to “Automatic”, it would show the following:
43880.62301
43880.6230092593
(Note that the above 2 is different, the “.62301” and “.6230092593”
In one format it’s the same, but in the other format is different. And my spreadsheet formula would see this two values to be different and caused issues with my sumif formula…
My question is, what can I do to eliminate this or overcome this problem?