https://app.clay.com/workspaces/47287/tables/t_OGVYr2yZC5zr/views/gv_R...

·

https://app.clay.com/workspaces/47287/tables/t_OGVYr2yZC5zr/views/gv_Rogiq3UnU9eV Struggling to get a formula to not return errors for when there is no source reference.

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Rubi S.
·
·
You can try adding "if X column is empty leave this cell empty" to the formula generator on top of what you have, it usually works for me.
Clay Team
APP
·
·
Yup! Just like Rubi said, that's usually the easiest approach for this. If you'd like to manually add the code it does that same evaluation, you can add the value's path in the following way at the beginning before the rest of the formula: {{Find Alternate Contact}}?.people && ...
Clay Team
APP
·
·
Joel B., took a peek at this and saw it was still returning errors so I tested out an alternate version of it to fix the errors. It's the column all the way at the end called "WORKING TEST" in case you'd like to check it out... I didn't prompt it anything because it was still struggling to output the right option