How do you change the beginning of the week to Sunday on a form?
Hello! I perceive this should be fairly simple to fix but it is perplexing to me! When staff are completing our form they frequently set a deadline of Saturday (we are closed on weekends) and I couldn't figure out why until I filled out the form myself and it shows the days of the week starting with Monday and ending with Sunday, so people are selecting the second last day of the week as the deadline, thinking it is Friday. I try to remedy this by editing the form, but it shows the days of the week as Sunday to Saturday when in the editing mode! Help! LOL See screenshots attached. The calendar appears as Sunday to Saturday in the sheet that the form is used for as well.
Answers
-
Very strange. I created a date column on a test sheet and a form from that and it displays by default how you want it to:
What happens if you create a new sheet with a date field and create a form from it? Does it display Sun-Sat or Mon-Sun? Also, are you in the US?
-
Is this form possibly made from a project sheet that has defined what days are working days?
-
@Mike TV We created another form recently and it's all good - the weeks in all calendars in the form and on the associated sheet are Sunday to Saturday. I am in Canada.
-
Glad you got it working.
-
@Mike TV Oh, no we didn't get it working, that was another sheet we created a form for recently. Maybe we will have to recreate this sheet at a later date when a disruption to the workflow won't a pain, but it would be nice to figure out how to simply fix it in this form so we don't have to send a new link to staff.
-
So this form that's not working isn't in a project type (gantt) sheet with the start day for week set to Monday is it?
-
@Mike TV Oh, no, it's a grid, not a project type sheet.
