For the Score Row in Clay, how do I check if a cell is a number above a certain value to assign a score? Or is the workaround to create a new columns that does the check and just see if it’s true?
For example, I selected Between (Number) above and have no idea how to set the range since the only field is Keywords
Hey, thanks for reaching out, It needs to have a - between . For example min-max (e.g. 5 - 10) You can see it via the tooltip on the Keywords part :) More on this integration: https://www.loom.com/share/0c0ccd9fc76f49a2ba2337c1a76d8d0f https://downloads.intercomcdn.com/i/o/w28k1kwz/1254445143/72b6329e31dbeb86228a27977698/CleanShot+2024-11-16+at+_36eBy2waTs%402x.png?expires=1731787200&signature=29e969eb43d04b7ba9af7f355cd85068b155dbf0f42d2cacb25dc4aee272c77a&req=dSIiEs16mIBbWvMW1HO4zTpGHrzLynVEQ7%2Btt7CjJKSy97HVDq1DRNbEIkOv%0At%2BUU%0A
Thanks
How would I check if a field is just non-empty?
What's your goal here? Typically, it would be better to do this with an AI formula if that's because you'd like to not have it run on those rows! There's no way to give an empty value a score for now! :) https://www.clay.com/university/lesson/how-to-use-ai-formulas
Just want to check if a company is using any tools. So as long as the cell is not empty, I’d want to add a point to the score.
Solution: Going to just create a formula {{Intent providers}}?.length > 0 and then check if boolean is true in score
Great idea!!! Well done! :)
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!