Place Multiple Categories in a Single Cell?

New Contributor

I'm trying to sort through data I'm inputting manually into a table and I'm wondering how to format a cell. I have a column for categories, and I want to assign one value to multiple categories. However, all it does is make the input into a new category. In my A column, I have a note. In my B column, I have the category that is assigned to that note. I am trying to assign multiple categories to a few of the notes, but it's not working how I intend. For example, one of my notes is "Use bulletin and mail from leadership in CDS for positive messaging and general resort/area updates" and the category is "Employees". The next note is "Put two-ply toilet paper in all Resort restrooms" and that category is "Resort 1". However, I have a note that applies to two categories: "Resort 1" and "Resort 2". What do I put into the cell that allows me to assign both of those categories, and filter them if I need to, instead of it creating a new category that just says "Resort 1, Resort 2"?

2 Replies

 

Screenshot 2022-06-03 Excel.jpg

@whalebait99  Here is a screenshot exemplifying what I mean.

@whalebait99 

I'd keep Category as single value and repeat (copy/paste) Change for each other category.

Same "Put toilet paper" could be completed for Resort 1 and uncompleted for Resort 2, priorities could be different for different categories, etc.