Assistance Needed: Company Enrichment and Conditional Formula Error

Nidhi T. · 2025-08-31 01:19:57.601309+00

hello team, i need help with company enrichment with adding funding stage column, inout i am providng is domain. when i try to add the comditional formula using AI to run it only when company has /employee count < 200 ; it gives an erro saying input us missing and infact the output itself for the fomula is incorrect too

Assistance Needed: Company Enrichment and Conditional Formula Error | Clay

14 comments

· Sorted by Oldest

Nidhi T.
·
·
next when i save and run 10 rows it says "inputs are missing" i added domain as input. what else should i be adding as input and how?
Nidhi T.
·
·
do you mean i shoudl repalc e employee_Count with "SIZE" column in the use AI formiula?
Nidhi T.
·
·
when i do that it provides the wrong output
Nidhi T.
·
·
okay formula worked but still says inputs are missing
Nidhi T.
·
·
can you give me the exact formula
Nidhi T.
·
·
i corrected the formula however still it says "inputs required"
Haider S.
·
·
In Clay, don’t use AI for the condition directly.
a.
First add Employee Count Enrichment on the domain.
b.
Then create a Filter/If Formula column → IF(Employee Count < 200, Funding Stage, "").
c.
Finally, run the Funding Stage enrichment only on rows that passed the condition.
👉 This way no “missing input” error, and Funding Stage column fills only for companies <200 employees. Let me know if you need any other help feel free to dm ☺️
Nidhi T.
·
·
here is what i am doing , do i need to add condtion to tjis? i guess not.
Nidhi T.
·
·
hi , i think i could get the employee count. But I didn add the <200 employee count filter. How do I now add tht filter to this column so only companies with <200 are employee count are displayed
Nidhi T.
·
·
great. how does one get to know about the "source" from the column name employee count column
Nidhi T.
·
·
wehre is the source
Nidhi T.
·
·
i cant find the source in "editing employee count" column
Bo (.
·
·
Nidhi - Do you mind sending the link (url) to the table so we can take a look?
Nidhi T.
·
·
https://app.clay.com/workspaces/748817/workbooks/wb_0t1qdifebGifdJzRPso/tables/t_0t1rqor88kw6SS4KC3x/views/gv_0t1rqosx84psKpqA8YA

Loading comments

Nidhi T.
·
·
next when i save and run 10 rows it says "inputs are missing" i added domain as input. what else should i be adding as input and how?
Nidhi T.
·
·
do you mean i shoudl repalc e employee_Count with "SIZE" column in the use AI formiula?
Nidhi T.
·
·
when i do that it provides the wrong output
Nidhi T.
·
·
okay formula worked but still says inputs are missing
Nidhi T.
·
·
can you give me the exact formula
Nidhi T.
·
·
i corrected the formula however still it says "inputs required"
Haider S.
·
·
In Clay, don’t use AI for the condition directly.
a.
First add Employee Count Enrichment on the domain.
b.
Then create a Filter/If Formula column → IF(Employee Count < 200, Funding Stage, "").
c.
Finally, run the Funding Stage enrichment only on rows that passed the condition.
👉 This way no “missing input” error, and Funding Stage column fills only for companies <200 employees. Let me know if you need any other help feel free to dm ☺️
Nidhi T.
·
·
here is what i am doing , do i need to add condtion to tjis? i guess not.
Nidhi T.
·
·
hi , i think i could get the employee count. But I didn add the <200 employee count filter. How do I now add tht filter to this column so only companies with <200 are employee count are displayed
Nidhi T.
·
·
great. how does one get to know about the "source" from the column name employee count column
Nidhi T.
·
·
wehre is the source
Nidhi T.
·
·
i cant find the source in "editing employee count" column
Bo (.
·
·
Nidhi - Do you mind sending the link (url) to the table so we can take a look?
Nidhi T.
·
·
https://app.clay.com/workspaces/748817/workbooks/wb_0t1qdifebGifdJzRPso/tables/t_0t1rqor88kw6SS4KC3x/views/gv_0t1rqosx84psKpqA8YA