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?
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives