Hello, Smartsheet!
Longtime listener, first-time caller ...
I have a Target Release column (Date), and the range of date values is vast. Because of date field requirements in a legacy system, we use values far off in the future to indicate "N/A" when a date value was required (e.g., 01/19/2405, 12/01/2999). These records were brought into Smartsheet. For sheet rows with these far-out Target Release values, we are having trouble with updating them with a new date (e.g., 03/27/2021). We can delete the current value (12/01/2999), leave blank, and save the sheet (or update with "N/A" in the date field). However, when we try to update the Target with a date value after the save, the field reverts back to the far-out date that existed PRIOR to the last save of the sheet. It's actually the first time I've seen this behavior of reverting beyond the "undo" reset saves cause.
So, is there something we can do to 1, update these values without having them revert, or 2, should we export these rows, manually update the values in the export, and paste them back in as new rows without far-out values? Also, should we stop the practice of using far-out dates moving forward to avoid this issue completely?
One other note: There cross-sheet references to to our Target Release field, but no formulas or calculations exist in the field now.
Thanks for your time,
Jared
