Today() Update when rows added through Automation
The documentation for the Today() Function lists the conditions under which a formula using Today() will and will not update to the current date.
There is no mention of what happens when rows are added to a sheet from another sheet via a MOVE or COPY automation. It does say that if rows are added via a FORM SUBMISSION, the Today() function updates. I would assume a similar behavior - but I need confirmation.
Also worth noting is that my formula is a Sheet Summary Formula. No mention in the documentation if that alters behavior.
Does anyone know definitively what behavior to expect?
I am aware of the workaround that uses a "Today Helper" column coupled with daily automation to populate it. I am trying to avoid using that because my formula also evaluates the Created Date and Modified Date. I don't want to update every row each day because that action contaminates the Modified Date.
Help Article Resources
Check out the Formula Handbook template!