FYI Colin P.
https://app.clay.com/workspaces/44164/tables/t_VhddfA2ROA5k/views/gv_dtWvALYQzTZi
https://app.clay.com/workspaces/44164/tables/t_XK7NeztZQyyJ/views/gv_0D8O3UfSA6Pe
That's weird, thanks will do that!
https://app.clay.com/workspaces/44164/tables/t_LqVv5u0FMItY/views/gv_EF5Tgf9woQd3
Arturo O.?
Thanks Arturo, the Developer 1 column looks good now, what about the Developer 2 column it should check if there are more than 1 companies with letter (D) and if so should get the second developer name.
and this is the table that the same formulas are working correctly https://app.clay.com/workspaces/44164/tables/t_lPzuQqUS9Hei/views/gv_2ZsOcfgapL20
https://app.clay.com/workspaces/44164/tables/t_h0XEh9dwAgOr/views/gv_3Iysf3os4dsH
Matthew Q.?