Join the Community

Home
Directory
Events

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

Community Guidelines

Powered by Tightknit

How to apply a formula that separate an output from 1 column in two.

·

·

How to apply a formula that separate an output from 1 column in two.

5 comments

Aamir B.
·
·
https://app.clay.com/workspaces/199708/tables/t_hsdwFYg7aDDA/views/gv_sGbaJpC4XNJ2
Jani V.
·
·
Hey Aamir, I don't think you can solve this with only one formula let's say column a is full name, you want to split it into first name and last name
you need to set up column B, to get the first name
and also set up column C, to get the last name
👍1
🔥1
Jani V.
·
·
hope it helps!
Clay Team
APP
·
·
Thas correct! would look like this:
f4608c92-aa6c-40cf-b04b-bca5235a1d5f.png(70 kB)
🔥1
Clay Team
APP
·
·
Yup!! In case it helps -> Here's a video of how to Split or Combine names (and more) with formulas: https://www.loom.com/share/75cf18efe4bf47979c6b4868d1594e6c