Is there a formula that would automatically change its date to reflect the date a cell or column changes?
For example, I am creating a sheet where I want a formula that changes its date to reflect anytime someone changes the task, so the person changing the task's status doesn't have to change the date they updated the task either. Instead it automates for them.
Thanks in advance!