Troubleshooting Invalid Formula Issue & Copy Pasting in Clay | Clay.com

·

How is this possibly an invalid formula? The part underlined in purple was there and working before. The new part was copy pasted from a working column. The only difference is the parenthesis, which often give me issues in Clay. Thank you https://app.clay.com/workspaces/11439/tables/t_m7VKBoIVLCKP/views/gv_onlJCMKmso3L

· Sorted by Oldest

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 😉
Clay Team
APP
·
·
Hey Matt!! Yeah, the logic on when parenthesis are used and when they cause issues is still not very clear. I believe you can change the order of the argument and send the argument within the parenthesis to the beginning and it should work. The team knows of this and is checking out options of what values could be supported and how to improve the formula creation process.
Matt R.
·
·
Huh… very interesting. I’ll try that. Thank you Arturo cc Matt F.

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 😉
Clay Team
APP
·
·
Hey Matt!! Yeah, the logic on when parenthesis are used and when they cause issues is still not very clear. I believe you can change the order of the argument and send the argument within the parenthesis to the beginning and it should work. The team knows of this and is checking out options of what values could be supported and how to improve the formula creation process.
Matt R.
·
·
Huh… very interesting. I’ll try that. Thank you Arturo cc Matt F.