Hey guys.
So, I'm curious if there's a way to do something. I want to detect certain changes in a cell, and modify another cell based on the date those changes occur.
The goal here is to automate the entry of dates of completion. I've thought about entering the following formula in a date cell: =IF([% Complete]2024 = 1, TODAY(), 0)
this formula works, but I'm thinking what it's going to do is just keep updating to be the current day every time the sheet is opened or refreshes, that's not really desireable. I really just need it to update that value once, upon change to 100%, and then never do anything ever again. Any ideas?