Referencing date and time from another sheet
I am trying to reference an automated creation column from sheet A to populate date AND time in a column in sheet B. I have been successful in the reference, but then have to format the receiving column to date format due to invalid data type. Problem is I need the time to populate as well.
Also, when writing this formula this morning, many of the columns having a creation date of 8/6/20 on sheet A are populating as 8/7/20 in sheet B.
Help Article Resources
Check out the Formula Handbook template!