Date Helper Not Helping


I created a driver check in and the shipper wonder if there was a way that they could see when a line last pick up. So I used the a date helper and a time helper to separate the information and I used a separate sheet to pull the information. The date helper formula i am using is:

=DATEONLY(Created@row) + IF(AND(VALUE(LEFT([Time Created]@row, FIND(":", [Time Created]@row) - 1)) <> 12, VALUE(LEFT([Time Created]@row, FIND(":", [Time Created]@row) - 1)) >= 5, FIND("P", [Time Created]@row) > 0), 1)

But you can see in the picture it not working that well. Any check in it puts the date two days ahead then after midnight it goes back to that date. What am I doing wrong?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!