Troubleshooting Formula Discrepancies with Clay Table: Help Needed!

·

Hey Guys, I am using the same formula on 2 clay table and on the second one is not working. at the developer 1 column the example output is correct and when I click Output is correct. Save formula it doesn't give me the same output.

✅

1

7 comments

· Sorted by Oldest

Ervin Rapo
·
·
https://app.clay.com/workspaces/44164/tables/t_h0XEh9dwAgOr/views/gv_3Iysf3os4dsH
Ervin Rapo
·
·
and this is the table that the same formulas are working correctly https://app.clay.com/workspaces/44164/tables/t_lPzuQqUS9Hei/views/gv_2ZsOcfgapL20
Clay Team
APP
·
·
Hey Ervin, thanks for reaching out! taking a look
Clay Team
APP
·
·
Took a few minutes but was able to prompt it to something different after a bit of testing. You can take a look at the Developer column that was giving you issues to check the prompt if it helps in future casesLet me know if you run into any other issues!
Ervin Rapo
·
·
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.
Ervin Rapo
·
·
Arturo (Clay)?
Clay Team
APP
·
·
Ervin Rapo just added this!

Ervin Rapo
·
·
https://app.clay.com/workspaces/44164/tables/t_h0XEh9dwAgOr/views/gv_3Iysf3os4dsH
Ervin Rapo
·
·
and this is the table that the same formulas are working correctly https://app.clay.com/workspaces/44164/tables/t_lPzuQqUS9Hei/views/gv_2ZsOcfgapL20
Clay Team
APP
·
·
Hey Ervin, thanks for reaching out! taking a look
Clay Team
APP
·
·
Took a few minutes but was able to prompt it to something different after a bit of testing. You can take a look at the Developer column that was giving you issues to check the prompt if it helps in future casesLet me know if you run into any other issues!
Ervin Rapo
·
·
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.
Ervin Rapo
·
·
Arturo (Clay)?
Clay Team
APP
·
·
Ervin Rapo just added this!