Sign in to join the conversation:
When refreshing the odbc connection, the date format has changed.
Hi Mark,I understand that you are seeing unexpected behavior with how Date fields are syncing with the Smartsheet Live Data Connector into Excel. Our Development team is aware of this date formatting issue affecting the Live Data Connector and are currently investigating this as urgent priority.I will reach back as soon as there has been a fix made by our Dev team.Thank you,Michael
Smartsheet Support
Hi Mark ,
Thank you for your patience while our Development team has worked through the unexpected behavior affecting date fields with the Smartsheet Live Data Connector. Our Development team has confirmed that this is now resolved and Date values should now sync to the connected application successfully.
Please try using the Smartsheet Live Data Connector with Excel now and reach back if you are still seeing invalid or null dates and I will help investigate further.Thank you,MichaelSmartsheet Support
I tried to sign into my Smartsheet portal it asked for an authenticator code. I don’t have one and I can’t find the QR code to authenticator to my own Microsoft authenticator app. Can anyone help me?
Hello. I need to send a sheet to multiple different people and I want them to only be able to interact with their specific row. Is this possible? eg: 10 rows(person A, comment) I want Row 1 to go to person A and for them to only see their row and only comment in their specific section, Row 2 → person B, etc, etc. Any help…
I have a Resource Table with… Resource ID Name DailyRate ValidFrom R01 Resource X $1,500 3/8/25 R01 Resource X $2,000 9/1/25 R01 Resource X $2,200 9/31/25 I also have a Week by Resource Table with… WeekID ResourceID WCDate ValidRatePerWeek W01 R01 3/2/25 auto-pop $1,500 W02 to W26 R01 All the dates for W02 to W26 auto-pop…