Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Need Help with Assignment 3 Output Issue | Clay

Need Help with Assignment 3 Output Issue

·

·

Hello Clay S. I'm having an issue with assignment 3 whereby it's not outputting correctly... Despite the formula being correct (as far as i can tell! See below) the output is blank (also below) any help would be amazing this bug has eaten ALOT of time. thanks!

Loading attachments

5 comments

· Sorted by Oldest

Clay Support
APP
·
·
Your formula is likely failing due to missing data handling. The issue occurs when your formula assumes there's always a value in the "Latest funding merged" field, but some rows may be empty.
Add error handling to check if the field exists before processing:
if([Latest funding merged] != "", Number( tostring([Latest funding merged]) .tolowercase() .replace("k", "000") .replace("m", "000000") .replace("b", "000000000") ) > 1000000, false )
This prevents the formula from breaking on empty fields and returns false for missing data. [1] You can also click into the specific cells showing blank outputs to see more detailed error messages.
If you're still getting "Error evaluating formula", try refreshing your browser with Cmd/Ctrl + Shift + R.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help resolving the issue with your formula or the blank outputs, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific errors you’re encountering?
Lemar M.
·
·
The refresh of the browser worked! Thanks for your help and hope this helps other people down the line...
Clay Support
APP
·
·
Glad to hear the refresh did the trick! If you have any more questions or need further assistance, feel free to ask.