# Combine Tags from Multiple Templates (Travel Planner, Cat Template) into Unique Column

**URL:** <https://community.tiller.com/t/combine-tags-from-multiple-templates-travel-planner-cat-template-into-unique-column/11129>\
**Category:** gSheets Templates\
**Tags:** showtell-votes\
**Created:** [January 13, 2022, 7:12pm UTC](https://community.tiller.com/t/combine-tags-from-multiple-templates-travel-planner-cat-template-into-unique-column/11129 "2022-01-13T19:12:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [January 13, 2022, 7:12pm UTC](https://community.tiller.com/t/combine-tags-from-multiple-templates-travel-planner-cat-template-into-unique-column/11129/1 "2022-01-13T19:12:37Z")

</div>

**What is the goal of your workflow? What problem does it solve, or how does it help you?**  
I have a few tags I use in my reporting and I’ve also added the Community Solutions for [Travel Planning](https://community.tiller.com/t/how-to-use-the-travel-planner-template/11061) and [Category Schedule](https://community.tiller.com/t/how-to-use-the-category-schedule-template/10976). In my Transactions sheet, I want a drop down to select a tag that includes all the tags I’m using in Tiller.

**How did you come up with the idea for your workflow?**  
I looked for a way to combine multiple sources and then de-duplicate them to provide one list of tags to select from.  
**Please describe your workflow. What are the sheets? Does it use any custom scripts or formulas?**  
It uses a formula that is easily modified in the event a new template is used.  
First, I have a worksheet called Tags where I list in Column A all my manual tags that I have. On the next available row in Column A, I have the following formula:

```auto
=unique(flatten('Category Schedule'!E21:E,'Travel Planner'!L4:L))

```

What this does is first get a list of my tags from the Category Schedule, and the Travel Planner. After that, it dedupes and provides a list of tags used. You can then go to the Transactions sheet and add the data validation to the Tag column, using  
`=Tags!$A$1:$A`  
**Anything else you’d like people to know?**  
On the Tags sheet you might find blank rows, this is OK and won’t make a difference to the formula.  
**Is it ok for others to copy, use, and modify your workflow?**  
Yes.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [January 13, 2022, 8:26pm UTC](https://community.tiller.com/t/combine-tags-from-multiple-templates-travel-planner-cat-template-into-unique-column/11129/2 "2022-01-13T20:26:55Z")

</div>

Super cool. You work fast, @yossiea!

I love that you have already integrated @catpatriciamorgan & @Brad.warren’s templates into your workflow just a few hours after they launched. 🚀

To remove the blanks, you could probably add a `FILTER()` into your formula:

```auto
=sort(
  unique(
    flatten(
      FILTER('Category Schedule'!E21:E,'Category Schedule'!E21:E<>""),
      FILTER('Travel Planner'!L4:L,'Travel Planner'!L4:L<>"")
    )
  )
)

```

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [January 13, 2022, 8:55pm UTC](https://community.tiller.com/t/combine-tags-from-multiple-templates-travel-planner-cat-template-into-unique-column/11129/3 "2022-01-13T20:55:19Z")

</div>

Thanks for the tip!  
As for integration, that’s always faster than implementation. 🙂 Plus, it’s always fun to prepare for a vacation.

---

<div class="post-metadata">

**Author:** ![peter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/peter/32/27_2.png) [@peter](https://community.tiller.com/u/peter)\
**Post date:** [January 13, 2022, 9:16pm UTC](https://community.tiller.com/t/combine-tags-from-multiple-templates-travel-planner-cat-template-into-unique-column/11129/4 "2022-01-13T21:16:39Z")

</div>

boom! so fun to see your workflow @yossiea

---

<div class="post-metadata">

**Author:** ![allison91](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/allison91/32/7912_2.png) [@allison91](https://community.tiller.com/u/allison91)\
**Post date:** [January 23, 2022, 8:13pm UTC](https://community.tiller.com/t/combine-tags-from-multiple-templates-travel-planner-cat-template-into-unique-column/11129/5 "2022-01-23T20:13:30Z")

</div>

This is awesome, thanks so much! I have a very long list of tags and would ideally have the dropdown of tags be dynamic to the specific category. For example, for my “Misc Income” category I would like to have a certain set of tags show up (Bonus, Stipend,Partner1, Partner2), and for “Shopping” category I would like a different set of tags to choose from (Clothing, Fitness, Beauty,Tech). I like to use my tags to be very granular to keep everything clean/not have too many categories. The ability to have a dropdown of tags to help with this would be amazing!