Transforming HubSpot Contact Owner Numbers to Names Using Formula

i have a "Contact Owner" column in one of my tables that is imported from HubSpot, so the values are presented as numbers vs. names. Is there a way to write a formula that can transform the numbers to names?

3 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Flo
·
·
nope, you need to create a mapping table in clay with your hubspot users and then do a lookup in other clay table
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.