Automatic Status Update When Another Cell Value Is Updated With Any Date
I have a worksheet where employees log details of applications received. I’m trying to work out a formula that lets the status of the applicant auto-update to caregiver in a target cell, when there’s any date input in another cell.