I have a user form for storing data in a datasheet. When I retrieve the data stored in the datasheet through the search button in the user form, the data appears in the user form but the formula I included, such as Today(), disappears.
For instance, when I input the Today() formula in the user form, it vanishes upon data retrieval.
I attempted to preserve the formula using app script to reapply it in the user form after data retrieval for updating, but the attempt was unsuccessful.
New contributor
Natharsha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.