Formula to enter date once a task is complete or criteria is met

Within our task list, we are trying to avoid additional work but having the date entered (in 'DATE COMPLETED' column) automatically once another field is either 'Complete' or 'N/A' ( Complete & N/A are 2 options from a dropdown list in another column. Thank you!


Best Answer