# 🙋‍♀️ User Profile columns in conditions and columns

**URL:** https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093
**Category:** General
**Created:** [April 29, 2020, 2:51pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093 "2020-04-29T14:51:48Z")
**Posts on this page:** 1
**Showing post:** 54

<div class="post-metadata">

### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [May 5, 2020, 3:30pm UTC](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/54 "2020-05-05T15:30:05Z")

</div>

Figured it out!

Created a new sheet with all Jobs listed (used a Unique function that combines and sorts the Jobs columns in the User Profile sheet ---- =sort(UNIQUE(PROPER({‘User Profile’!G2:G;‘User Profile’!H2:H})))).

This gives me a column I can use to create a relation from the array of job titles to the UNIQUE column in the Jobs sheet.

Once I have that relation done, I can add a Lookup in my other sheet that pulls in the Jobs Relation values.

It’s hard to explain but it works!

---

_[View the full topic](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093)._