Why do two Smartsheet sheets show same dates differently despite confirming format and timezone?
I've noticed a discrepancy in the displayed dates between two Smartsheet sheets, despite having checked for common reasons like date format, timezone settings, and data entry errors. What other factors should I consider to troubleshoot this issue effectively?"
Answers
-
Hey @Swamini Vats
For clarification, could you be more specific in what was verified for timezone differences? Are the owners of both sheets from the same timezone? Are the users of both sheets entering data in the same time window? Are the date discrepancy occurring all throughout the day, or only at specific time windows (like 4pm - 8pm, etc).
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!