HI I am finding the following issue in form date format.
My regional setting is set to DD/MM/YYYY
But when setting up the form, it is showing MM/DD/YYYY
How can I rectify this so it is a streamlined format?
Hey @Vivien Chong
Apologies, I had different personal settings (Canadian) which is why mine show YYYY-MM-DD
This means in your case, since you're not asking them to sign in, other users should also see DD/MM/YYYY since that's your setting.
The MM/DD/YYYY shown in Form Builder is purely just for the Builder display - there's no current way to display different date formats while setting up the form, it doesn't have the custom ability that a Live form has. Does that make sense?
Hi @Vivien Chong
This date format only shows during the set-up process for the Default Value in a Form. Once you've decided on a default value, for the form submitter it actually appears as YYYY-MM-DD to be universal.
Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community.
Hi @Genevieve P. thanks for your feedback.
I do not think the YYYY-MM-DD is universal in the form.
The following is my form setting that shows MM/DD/YYYY despite my personal setting of DD/MM/YYYY.
This is the form from the above form setting, for the form user it is showing DD/MM/YYYY as per my personal setting.
In this case, is the form setting just showing a default MM/DD/YYYY for everyone. While the actual form will follow the owner's date format setting?
Do you have your form settings restricted so your users need to sign in to fill out the form? If this is the case, then the Form should respect each individual's Personal date format (in your case, DD/MM/YYYY).
HI @Genevieve P. I just checked my form setting and I am not restricting users to sign in before accessing the form.
I open the form link in private browser, it is showing DD/MM/YYYY, which is what I need.
But it is not the universal YYYY-MM-DD.
Trying to understand how it works.
Does my computer setting cause the date to show up as DD/MM/YYYY?
The MM/DD/YYYY shown in form setting is just default setting?
Actual form user will see the date format as per my Smartsheet setting or their personal computer setting?
@Genevieve P. thanks for the explanation.
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.