I work with multiple excel sheets that have various tags on each one but many of the same people. When I import a sheet with Tag columns, the “pre-import tags” are 1) overwritten and replaced (and the previous ones deleted) if I choose the [overwrite] function on import OR 2) they don’t appear at all if I choose the [skip] button on import.
I would like to add tags to a person on import using the [overwrite] function, not completely replace the tags.
For example, let’s say Excel sheet Alpha marks Janet with tags that indicate she likes “football” and “softball.” I import. Tags are added to Janet (and 300 others) that say “football” and “softball.” 3 weeks later I acquire new information: Janet likes Karate too, so I start Excel Sheet Beta (because Janet told me this in a google form which generates a google sheet which I download as an excel sheet and name Beta). I add tag “Karate” to Janet and 147 other people. Next is tricky. If I import and overwrite, then it tags Janet as “Karate” and deletes “football” and “softball.” If I import and skip, it doesn’t add “karate” and just keeps “football” and “softball.”
I made Janet up. I will send a box of homemade chocolate chip cookies to the person who can dig me out of this conundrum.
Best answer by Michelle from Copper
View original