Modified Date column not working

I have always done a 'save as new' with all of my sheets to archive data and then changed the Created Date column to Modified Date, that way it keeps the original created date of the rows in the archived version. However recently the Modified date is not changing, it is just mirroring what the created date field is. What did SmartSheet do that made this break. I have to "archive" my sheets like this because of the cell/row limitations. However being in the medical field we need our original created dates on the "archived" sheets for Audit purposes. Anyone have a fix?
Answers
-
@Kari G I'd actually have thought the current functionality is how it always should have worked, when you save as new those are new row's / row id's so the metadata on those new rows should commensurately reset. You're options are
1. Use an automation to hard log a date column for created date
2. Resolve scale issues, would need to know more about the use case for this but in general if you are constantly hitting scale limits the solution likely needs to be updated / rearchitected
3. Wait for table view to get full support for all functionality as this will bump all limits upPrincipal Consultant | System Integrations
Prime Consulting Group
Email: info@primeconsulting.com
Follow us on LinkedIn!