Issue with Data Not Pulling Through: True/False in Formula Section

Jade P. · 2025-10-28T21:12:54.313Z

My data is not pulling through. But in the Formula section it is showing as True and false?

Issue with Data Not Pulling Through: True/False in Formula Section | Clay

10 comments

· Sorted by Oldest

Clay Support
APP
·
·
Based on your screenshots, your formula is working correctly but the column appears stuck. Try these solutions:
Force rerun the column:
Click the "Funding > $1M" column header
Select "Force Rerun Column" from the dropdown
If that doesn't work:
Delete the affected column
Create a fresh column with the same formula
This often resolves processing issues
Check for formula logic issues:
Your formula might need additional logic to handle missing data. Consider adding a condition like IF({{Final Latest Funding Merged}} exists) before your comparison to prevent errors when data is missing
Click into specific cells showing issues to see detailed error messages that can help identify the root cause.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help resolving the issue with your formula or data not pulling through, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific problems you’re encountering?
Jade P.
·
·
I am running it now so I will tell you shortly
Clay Support
APP
·
·
OK, take your time. I'll be here when you're ready to share more details or if you need further assistance.
Jade P.
·
·
Now it isn't returning checkboxes?
Clay Support
APP
·
·
The "Funding > $1M" column is showing "true" as text instead of checkboxes because its data type is set to "Text" rather than "Checkbox." To fix this, change the column’s data type:
1.
Click the column header for "Funding > $1M."
2.
Select "Edit column" or "Select Data Type."
3.
Choose "Checkbox" as the new data type.
4.
Click "Save settings."
This will display checkboxes for boolean values in the column. [1] [2] [3]
Clay Support
APP
·
·
Is that what you were looking for?
Jade P.
·
·
Excellent, thank you so much. It is working now
Clay Support
APP
·
·
Great! I'm glad to hear it's working now. If you have any more questions or need further assistance, feel free to ask.

Clay Support
APP
·
·
Based on your screenshots, your formula is working correctly but the column appears stuck. Try these solutions:
Force rerun the column:
Click the "Funding > $1M" column header
Select "Force Rerun Column" from the dropdown
If that doesn't work:
Delete the affected column
Create a fresh column with the same formula
This often resolves processing issues
Check for formula logic issues:
Your formula might need additional logic to handle missing data. Consider adding a condition like IF({{Final Latest Funding Merged}} exists) before your comparison to prevent errors when data is missing
Click into specific cells showing issues to see detailed error messages that can help identify the root cause.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help resolving the issue with your formula or data not pulling through, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific problems you’re encountering?
Jade P.
·
·
I am running it now so I will tell you shortly
Clay Support
APP
·
·
OK, take your time. I'll be here when you're ready to share more details or if you need further assistance.
Jade P.
·
·
Now it isn't returning checkboxes?
Clay Support
APP
·
·
The "Funding > $1M" column is showing "true" as text instead of checkboxes because its data type is set to "Text" rather than "Checkbox." To fix this, change the column’s data type:
1.
Click the column header for "Funding > $1M."
2.
Select "Edit column" or "Select Data Type."
3.
Choose "Checkbox" as the new data type.
4.
Click "Save settings."
This will display checkboxes for boolean values in the column. [1] [2] [3]
Clay Support
APP
·
·
Is that what you were looking for?
Jade P.
·
·
Excellent, thank you so much. It is working now
Clay Support
APP
·
·
Great! I'm glad to hear it's working now. If you have any more questions or need further assistance, feel free to ask.