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.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!