Dateformat changes in external linked sheets

I've created a table to manage our school-year. Out of this table several calendars should be created. As there is no possibility to create more than one calendar out of one tablesheet I worked with markups and created external links to some other tablesheets so that there is one sheet for every group I have to manage. Unfortunately the dateformat changes from "dd.mm.yy" in the original table to "mm/dd/yy" in the linked table. The calendar does not publish these dates. How can I have smartsheet to avoid changing the dateformat?
Comments
-
Hi Matthias,
If I understand you correctly, you have one master sheet thatΒ youΒ are linking to other sheets and using the calendar in each sheet. Is that correct?
Have a fantastic week!
Best,
AndrΓ©e StarΓ₯
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello Matthias,
Smartsheet uses your Language (Country) setting to dictate your default date format (e.g., mm/dd/yy or dd/mm/yy). Since the dates are being cell linked, I would recommendΒ reaching out to our Support team, providing them with the names of the affected sheets, in order to refresh the cell links.
If you're interested in more information on the Language (Country) setting, see:Β https://help.smartsheet.com/articles/796268-adjusting-personal-settings
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 203 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives