Using IF and unchange the cell value if it happens to be false.
I have this worksheet
Column B is a drop list of variables - "Completed", "In Progress", "Enrolled", etc.
Column C is Date Completed (meaning if the learner completed the course, we stamped the date when this learner completed the course.
So when I input in the date, I would like. Column B to change to Completed form whatever status it is.
I tried this formula -
=IF(NOT(ISBLANK([Date Completed]@row)), "Completed", Status@row)
But I got the error "Circular Reference" which means sense because I tried to refer back to the original cell.
Is there a way for me to ignore any other status and change the status if the date is presented?
Help Article Resources
Check out the Formula Handbook template!