Date column changing the default behavior of a column

Cecelia Martin

I have a date column called Date of Resolution .  I also have a column next to it called Resolved? which is a drop down of either YES or NO.

 

What I want is the Resolved column to automatically fill in from the behavior of the Date of Resolution column.

 

If the Date of Resolution cell is filled in, then Resolved changes to YES

If the Date of Resolution cell is empty, then Resolved defaults to NO

 

How can I do this?

Benjamin Walker

=IF([Date of Resolution]1 = "", "NO", "YES")

 

This formula should work! It says that if the date is blank, then NO is used, but otherwise it will fill in YES. Its a bit simple, so if you need it to do more I can try to do so. Just let me know!

Cecelia Martin

Perfect!  Thanks