.png){kind=logo}
Help Needed: Referencing Columns from Different Tables in Formulas
Facing an issue referencing a column from an a different table in my formula. Any suggestions ?
Facing an issue referencing a column from an a different table in my formula. Any suggestions ?
To reference columns from a different table in your formula, you can use one of these methods:
1. Lookup Actions:
• Use Lookup Multiple Rows in Other Table
• Use Lookup Single Row in Other Table
These lookup actions allow you to reference data from any table in your formulas.
Important note: After creating new columns in the source table, you'll need to re-run the company row in the people table to see the new values in your formula. You may need to force run through the whole column to see the updated values.
finally worked
Thank you so much for sharing your feedback Afsha Haslani!
i have another question for you. I have a column check_domain in a table and everytime a domain is present i want to add 5 points. eg if a domain is present 1 time it will return 5 if 2 times it should return 10 points. My formula is returning only 5 points even if domain is present 5 times
To create a scoring formula that adds 5 points for each domain occurrence, you can follow these steps: 1. Add a new Formula column to your table 2. Use the Count Occurrences feature to count the domains, then multiply the result by 5. This will give you: • 5 points for 1 occurrence • 10 points for 2 occurrences • 15 points for 3 occurrences, and so on The formula should count the occurrences in your check_domain column and multiply that count by 5 to calculate the total points.
count occurences is not giving me a total occurence its giving only 1
To properly count all occurrences in your check_domain column, you should use the "Lookup Multiple Rows" integration instead of the Count Occurrences feature. The Lookup Multiple Rows allows you to scan a column for matching values and count how many cells exist with that value. For the Count Occurrences feature to work correctly, you need to ensure: 1. Your input is properly formatted (either as text or array) 2. You've specified the correct separator if using text input 3. You've set an appropriate limit (default is 99) If you're still having issues, try refreshing your browser using Cmd/Ctrl + Shift + R to resolve any formula evaluation problems.
not able to use the lookup multiple rows in the same table its working only for a different table
You can use the Lookup Multiple Rows feature to count occurrences within the same table. The feature allows you to scan a column for matching values and count how many cells exist with that value, and this works both within the same table or on a separate one. Keep in mind that when using Lookup Multiple Rows, you can only use one column at a time as a filter - you cannot apply multiple columns as filtering criteria. To count occurrences in your check_domain column: 1. Add a Lookup Multiple Rows column 2. Select your current table as the "Table to Search" 3. Choose your check_domain column as the "Target Column" 4. Set your filter operator and row value to match the domain you want to count 5. The result will show all matching rows, which you can then count to get the total occurrences
i am writing to another table and entering columns for writing why is it saying enter valid lists
The "enter valid lists" error typically occurs when the values you're trying to write aren't properly formatted as a list. To resolve this issue: 1. Add the list through the "Other data from this table" section When setting up your Write to Other Table: 1. First select your Clay account 2. Choose your destination table 3. For column mapping: • If writing individual values, enter "/" to skip list selection • If writing lists, select the column containing your lists 4. Map your columns correctly from source to destination You can watch a detailed video tutorial on how to properly format and write lists at: https://cln.sh/DpHTlNt0
for lookup multiple rows it is not giving my current table in the dropdown to select from
The Lookup Multiple Rows feature can actually be used within the same table - you can scan and count values within your current table. If you're not seeing your current table in the dropdown, try refreshing your browser as this may be a temporary display issue. When using Lookup Multiple Rows, you should be able to: 1. Select your current table as the "Table to Search" 2. Choose your target column 3. Set your filter operator and row value
in table to search i am not getting my current table as an option
The Lookup Multiple Rows feature should allow you to scan and count values within your current table. If you're not seeing your current table in the dropdown, this is likely a display issue since the feature is designed to work both within the same table and across different tables. Try these steps to resolve the issue: 1. Refresh your browser 2. Check if you can see other tables in the dropdown 3. If the issue persists, you may want to explicitly request human support in this conversation for further troubleshooting.