I am looking for a way to create a static date/time when a specific action is completed in a cell. Currently we created the formula below, but we need it to return a specific static date not just todays date, which changes every day.
=IF(AND([Manager Approval]3 = 1, [Internal Processing Status]3 = "SERVICE COMPLETE"), TODAY())
Is there a formula for inputting a date that will become static?
We are unable to use a date modified column as the row will continue to be updated and modified in other cells as employees complete the billing process.
Thank you for the help.
