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?"

Tags:

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!