If I am doing this wrong, I apologize. I posted a similar question earlier, which was immediately responded to and solved. Later, it was determined we need to tweek that, so I replied to that "solved issue". But since it doesn't come up like it needs assistance, I was afraid it didn't get answered, so I am putting a new post for my newer version of what I am looking for. If that is wrong, I apologize in advance. I looked for "help" on the subject of adding to a solved post, but couldn't find my answer.
Here is what I need:
E2 is an install date
F2 is a disconnect date
G2 is where I would like the status to show
If E2 is populated, G2 should say "Active"
If F2 is populated, G2 should say "Disc"
If neither is populated, G2 should say "Vacant"
Please note, when the disconnect date gets entered into F2, both F2 and E2 will now be populated.
Thanks again for any assistance.
Bookmarks