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

How to Merge Columns and Treat FAILED as Empty Column | Clay

How to Merge Columns and Treat FAILED as Empty Column

·

·

how can I merge coloumns and treat a coloumn with the text "FAILED" as an empty coloumn, without creating an additional coloumn for it?

5 comments

· Sorted by Oldest

Guy M.
·
·
https://app.clay.com/workspaces/210823/tables/t_VojjWTV7tIAw/views/gv_5gc25Rn7V4Hq TAlking about the coloumn "Final merge"
Clay Team
APP
·
·
Guy, you can create an extra column with a formula condition, if "FAILED" = blank and then proceed
Guy M.
·
·
Yes, I mentioned that I want to avoid creating another coloumn
Guy M.
·
·
How about this? It looks like works, but want to make sure
Loading attachments
Clay Team
APP
·
·
Looks good to me!