Hello i am having an issue with a dynamic view in smartsheet. We have a dynamic view that is designed so that users can input tickets into a backend smartsheet sheet. The issue is when the user tries to add a ticket with a date, the dynamic view switches the date and month. This means for example if the user inputs a date like 10th of February 2024 (10/02/2024) in the calendar it shows as the 2nd of October 2024 (02/10/2024). If a date past the 12th of the month is input then the field appears blank in the dynamic view. Even stranger, when inspecting the backend sheet the dates are read correctly as expected.
here we select the 10th of February
The dynamic view however reads it as the 2nd of October.
However in the backend smartsheet the date is read correctly as the 10th of February 2024. hanks and looking forward to your response