Column properties not copying over into new added row
Hello- I have been using this Sheet for over a year with no issues to track expiration dates with conditional formatting for various reminders. Now, any added rows to one of the Columns are not carrying over the Column Properties for future dates. I removed the conditional formatting and its's still not working.
The Column, "Med Card EXP Date" is restricted to dates only. When I add a new future date, an override pops up. Any ideas on correcting this?
I have picked random rows within the Sheet, created a new column, and it still not accepting the new future date.
Answers
-
That's because there are rows with non-date values within the column such as "N/A".
-
Thanks for the response. I just removed all of the "N/A" from the column. Still does not allow me to enter a future date. The issue seems to be concentrated to this one row. I tried re-entering it at the bottom, and it still does not recognize the future date.
-
Exactly how are you trying to enter the date?