I am building a table where Column A contains the title of a client deliverable and Column B contains the date of the deliverable. Column B contains a drop down list of the dates of the current week. However, I only want Column B to be populated with a date if Column A contains text. This way, users can delete the text in Column A and the date selected from the drop down in Column B will automatically disappear without having to delete that cell as well. Is there any way to do this?
Thanks!
Bookmarks