Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Convert Formula Column to Static URLs in Excel | Clay

Convert Formula Column to Static URLs in Excel

·

·

I have a column that’s a formula from another column, and I deleted the the latter column because I don’t need it anymore. How can I turn the column shown in the screenshot into a pure url column rather than an output of the column I deleted?

Loading attachments

9 comments

· Sorted by Oldest

Channeled
APP
·
·
To convert a formula-based column into a pure URL column after deleting the source column: 1. Right-click on the column header 2. Select "Edit Column" > "Select Data Type" 3. Choose "URL" as the appropriate data type 4. Click "Save Settings" This will change the column's data type to URL, preserving the existing values without the formula dependency. If you need further assistance, please request human support by clicking on "Talk to a person" in the chat.
Sources: Select Column Data Type Table columns | Documentation | Clay University
Mike Fishbein
·
·
no it’s already a url column. see screenshot.
Mike Fishbein
·
·
Table: https://app.clay.com/workspaces/283560/tables/t_N55Ti4jCgmKk/views/gv_p45GwDBcXJ7f
owen (Clay)
·
·
Hey Michael, thanks for reaching out. Looking into this now. :)
owen (Clay)
·
·
Hey Michael, To remove the column inserted within the formula, simply: 1. Click on the column header 2. Select "Edit Column" 3. In the modal that appears on the right, find the column within the formula 4. Click into the text box and backspace to delete it You can see this process in the video below. :) Let me know if you need any further help!
Channeled
APP
·
·
Loading attachments
Mike Fishbein
·
·
If I delete it won’t I lose all the data that was populated by that field?
Bo (Clay)
·
·
Hey Michael - Yes sorry for this. You can copy the column and paste it into a text column or you can export it as CSV and re-import it without any issue. Curious what were you trying to do exactly here with that data?
Channeled
APP
·
·