Column properties not copying over into new added row

Nikki B

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.

Paul Newcome

That's because there are rows with non-date values within the column such as "N/A".

Nikki B

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.

Paul Newcome

Exactly how are you trying to enter the date?

3wing

I have this same problem - new rows do not have the column properties. For instance I have 12 columns that are all checkboxes - the new rows that are added do NOT have checkboxes in those columns. What gives? This is a new problem.