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?
LinkedIn
Twitter
