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".
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives