I’m sure I’m not the first to ask this. I could not find a post addressing my question.
I am creating a sheet to track invoices through a department; receive to payment.
I created a check box column titled 'January - Invoice Received' when the check box is checked i want the next column over titled 'January - Invoice Received (Date)' to display the date the check box is checked.
I have the 'January - Invoice Received (Date)' column type set to date and the formula I have is =IF([January - Invoice Received]3, TODAY()). The problem i have is when the sheet is re-opened all cells in the 'January - Invoice Received (Date)' column with entries update again to the current date.
Any help would be appreciated.