Smartsheet Cell Created

JonEric Eubanks

Can anyone figure out why this is happening? I have the date cell with =[Date4/7/20]@row but it's showing it as a different date. I cannot figure out a work around this bc using countifs to count today's date . So cant use =LEFT function.

Paul Newcome

It may be a time zone thing. Let's try this...

=DATE(VALUE("20" + MID([Date 4/7/20]@row, 7, 2)), VALUE(LEFT([Date 4/7/20]@row, 2)), VALUE(MID([Date 4/7/20]@row, 4, 2)))

Paul Newcome

Try a DATEONLY function.

=DATEONLY([Date 4/7/20]@row)

JonEric Eubanks

Thanks for the quick response but still no success, any other options?

Paul Newcome

It may be a time zone thing. Let's try this...

=DATE(VALUE("20" + MID([Date 4/7/20]@row, 7, 2)), VALUE(LEFT([Date 4/7/20]@row, 2)), VALUE(MID([Date 4/7/20]@row, 4, 2)))

JonEric Eubanks

Thank you so much =DATE(VALUE("20" + MID([Date 4/7/20]@row, 7, 2)), VALUE(LEFT([Date 4/7/20]@row, 2)), VALUE(MID([Date 4/7/20]@row, 4, 2))) worked!! Central time zone here.

Paul Newcome

Happy to help! 👍️

I can't remember all of the specifics on why it works that way for some time zones or even which time zones are affected and how, but I do know that others in the Community have posted about having the same issue. Glad we were able to get it working for you.