Date formatting to MM/DD/YYYY
Good afternoon. I need to format a DOB column to the MM/DD/YYYY format. Currently, the column type is set to Date and restricted to dates only. I don't see that as an option in the Smartsheet Date Format drop-down list. I have spent over an hour looking for the answer in this community and can't find it. I am now down to the wire to get this changed. Is there a formula that can be used? Or am I missing the obvious?
I really appreciate any help you can provide.