Skip to main content
Question

Use a Date as the smart container and having it formatted in a date format not a number

  • January 7, 2021
  • 3 replies
  • 42 views

Trevor H

I wish to use a date field (modified) as the Start Container title but every time I create the smart container it shows as number.

The modified field in the LucidChart dataset looks correct in the data format but when that is displayed as the title of the Smart Container it appears as a number.

I am using a Zapier zap to integrate from SmartSheet sheet to a Lucidchart dataset and then using that dataset to create the smart container. 

 

Comments

Clara H
  • Lucidite
  • January 8, 2021

Hi Trevor

Thanks for posting on the community! I don’t completely understand the issue you are trying to do. Could you send a screenshot of the smart container and the dataset that displays the title? 

Thanks in advance for your help and patience!

 


Forum|alt.badge.img
  • August 19, 2025

Hi, I am having this issue too.. please see below where the number in bold, imported from an Excel field in date format, is showing in Smart Containers as the date value.

 


Leianne C
Forum|alt.badge.img+15
  • Lucid support team
  • August 22, 2025

Hi ​@Martyn D, thank you for continuing this thread and sorry to hear you’re experiencing the same issue. Would you mind telling me what date format you are expecting to see instead of "45861"? If possible, a screenshot of how this appears in the dataset would also be helpful for us to better understand the issue. 

Thank you in advance for your help! Please let us know if you have any questions.