It seems like this would be easy, but I cannot find a solution.
On one tab I want a long Date format: Wednesday, October 7, 2020
This one is coming right into the sheet with a form.
On another tab, I want a shorter one 10/07/2020.
I have a relation and lookup pulling in the date from the first sheet.
How do I get the looked up dates into the shorter format?
Whenever I change the original, the looked up ones change.