My Pickup Date column is auto filling random dates. It wasn’t doing this before, but it suddenly appeared. This causes my Due Date field to auto-populate too since it’s set to add 42 days to whatever is in the Pickup Date field.
I can add a formula to have it set the pickup date to today as soon as the Check Out To field is entered. But I want the flexibility to be able to say that an item can be checked out on another day – just not today. If I try to get the field to go blank, I then lose the ability to click within the cell and get the popup calendar.
The view below shows there’s no formula for the Pickup Date column.