Smartsheet Cell Created
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.
Best Answer
-
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)))
Answers
-
Try a DATEONLY function.
=DATEONLY([Date 4/7/20]@row)
-
Thanks for the quick response but still no success, any other options?
-
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)))
-
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.
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives