Reporting Bug: Issue with Controlling Formula Field in People Table

Luke G. · 2025-12-11T15:20:58.395Z

Hello Support team, We are experiencing an issue where a controlling formula field which controls sending a company into people search does not populate in the People table after send sporadically. What is the proper channel to report this as a bug?

Reporting Bug: Issue with Controlling Formula Field in People Table | Clay

Clay Support
APP
·
·
You can report this bug directly here in this chat. To help us investigate, please provide:
• A summary of what's happening
• Any specific error messages you're seeing
• A link to the table where this occurs
• A screenshot if helpful
With these details, we can research what's causing the sporadic population issue with your controlling formula field.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with the issue regarding the controlling formula field not populating in the People table, I’m here to assist. Would you like to provide more details or continue troubleshooting this together?
Luke G.
·
·
OK, the initial Company search has a formula field called "Is Valid Company" which evaluates based on a set of criteria. This table then runs an Update People Table type column called '200+' that uses "Is Valid Company" = True in the 'Only run if' condition. ie: the People Search could never be updated in the first place unless this formula evaluates Once we move into the People table , we run a get request back to the Company table using a 'Company Lookup' column. This column should be able to return 'Is Valid Company' in the JSON since the formula is already evaluated. Sporadically, we are seeing an error (and in other workbooks a false value instead of true) which has downstream effects in the number of leads the workbook is able to identify for our sellers. Notice that some rows have actually evaluated and others have the error message. This is absolutely a bug and should be evaluated as such. tagging Guy H. who I believe has reached out about this previously.
Clay Support
APP
·
·
This looks like a data synchronization issue between your tables. Try these steps:
1.
Force run the Company Lookup column in your People table to refresh the connection
2.
Use Force Run in table settings for the "Write to another table" function if it's not processing correctly
3.
Click into the specific error cells to see more detailed error information
If the issue persists, try Sculptor (top-right corner) to help troubleshoot the workflow setup. You can also use the "Troubleshoot with AI" feature by clicking any error cell for tailored debugging instructions [1].
Let me know if these steps resolve the sporadic evaluation issue.
Clay Support
APP
·
·
Was this information useful?
Clay Support
APP
·
·
If you still need assistance with the sporadic evaluation issue in your tables, I’m here to help. Would you like to provide more details or continue troubleshooting this together?
Luke G.
·
·
Hi, this was not helpful, I would like an engineer to look at why the data is only syncing sporadically.
Clay Support
APP
·
·
I understand your frustration and will connect you with one of our human agents who can assist further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Luke G.
·
·
The table URLS are posted in my previous message describing the issue
Ashwin D.
·
·
Hey Luke - thank you for reaching out. To make sure I have all of the information, when using a "Company Lookup" column to get the data from the "Company Search" table, the "Is Valid" column returns different data. For example, sometimes it returns checkboxes, true/false values, or an error. Is that correct?
Luke G.
·
·
yes, that is the case. In the table s I've provided, though I've only been able to identify examples where it returns an error aka. neither true/false in the response
Daniela D.
·
·
Hey Luke! Thanks for reaching out. Happy to help. Looking into this and will follow up with an update🙏🏾
Luke G.
·
·
Hi Daniela D. thank you, appreciate the help and looking forward to the response.

25 comments