We have resource data in the Smartsheet so we can easily create Reports for managers and other purposes. For active employees, we have [End date] set up as 1/1/50 as a default.
when I enter as 1/1/50, it'll return 01/01/1950 instead of 01/01/2050🤦♀️🤦♀️
1. When I manually enter 1/1/50, this will turn into 1950 not 2050.
2. I also have a form attached to this sheet and if I default to 1/1/50 which will become invalid.. and turn it into 1950. Latest year I can set up is 1/1/40 (as 1/1/2040 without the glitch)
I feel like just typing 2 digit year code… should be defaulting to 2050 instead of 1950 moving forward. I reported this to SS Support desk and they told me they consider as "Enhancement request" 😶😶
Current workaround is to type in all 4 digit of the year, but we can't apply this to the Form because it'll glitches.