Forum Discussion
cathyb-hdc
Jan 27, 2020Copper Contributor
Data Validation Not Matching
I am using Excel to track individuals in our community who are homeless. We've used data validation to create a list of drop-down items in a column. At the moment the data validation list I have crea...
cathyb-hdc
Feb 03, 2020Copper Contributor
Hi theremathetes,
I am writing in regard to our list again. Since I have made these changes to the data validation there is now some difficulty when I try to change the status of an individual to Inactive. I'll attach a sample without names here. As you can see, in the past if someone was moved to 'Aged into Inactive' they would be marked as such in column B. Is this something you could provide some insight into?
Thanks.
cathyb-hdc
Feb 03, 2020Copper Contributor
mathetes Hi there - I figured out that I wasn't using the correct wording. Thank you for your help!
- mathetesFeb 03, 2020Gold Contributor
Always nice to figure these things out yourself!