I made a spreadsheet to update a location/site status when data is entered into specific cells. Column A is the location by Site ID, column H is the Assigned Tech, and Column I will be a yes or no entry once the work has been completed. I want the site status in L2 to update from "Not Started" to "In Progress" once a tech has been assigned and then "Done" once the done column has been marked. The formula I have seems to be working, but only for the first row. If I enter a Site ID into K2 that is any other row other than row 1, the status is "Not Started" even with data in the Assigned Tech and Done columns. Help please!
Bookmarks