Sign in to submit new ideas and vote
Get Started

Entering 2 digit year should bring the future year in the default setting.

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.

3
3 votes

Idea Submitted · Last Updated