copy rows automation with date formula
I have two sheets - one with routine tasks, the other with a list of assigned tasks. I have an automation built into the first sheet to copy rows to the second sheet on a regular basis. The first sheet has a date column which uses the TODAY() function.
I'm having a problem with items appearing on the second sheet with the wrong date. I know that the formula is lost in transit, but does Smartsheet evaluate the formula at the time the automation is run? Does the sheet have to be accessed for the cell contents to be updated prior to the automation?
Anyone with similar issues?
Help Article Resources
Check out the Formula Handbook template!