Hello,
I have a column in a production spreadsheet that I am utilizing to enter the date of which one of our production members completes an order. The columns are set up as follows - one column is an initials column where a production member selects their initials once they complete an order. The second column contains the formula "=TODAY()" which populates the current date of which a production member enters their initials (based off of the initials column).
What I am discovering is that this function is operating as expected throughout the week, but on Monday morning - anything that had the date of the Friday prior is replaced with Monday's date when the first person logs onto the production sheet. Example - production team completes orders on Friday 10/26, when the first user logs into the sheet on Monday 10/29, all of the orders with the date of 10/26 are replaced with 10/29 on the first instance of someone logging onto the sheet. What can I do to stop this, or what other function options are there to gather the date and make it stick?
Any ideas or advice of how to prevent this would be greatly appreciated!!! Thank you!
