I designed it in the form, collected the sender’s input date, and the application used the calendar to keep track. However, the display time is backwards compared to my design (dd / mm / yyyy). (same picture)
Following some tutorials, I have tried to apply the formula columM = TEXT (J2: J; “mm / dd / YYYY”), however this column M does not automatically update when there is new data information from sender. The M column is empty after the user has chosen to submit the form
Look forward to the instructions. Thanks very much