Scoring Accounts Based on Prospect Scores in a Separate Table

Hi, we have scored our accounts and our prospects, we would like to be able to give each account an additional score that is based on the sum of all the prospect scores within that account, it would require referencing another table - does anyone know how I can do this?

8 comments

Joe R.
·
·
Hey Josephine, do you have 2 separate tables for your accounts and your prospects?
Josephine V.
·
·
i do indeed
Fabian H.
·
·
you can use „lookup multiple rows in table“ and then search based on an account identifier like domain and then add up the scores of the results
Joe R.
·
·
Yup what Fabian said. So inside your accounts table,
1.
create a column “Look Up Multiple Rows in Table”,
2.
set the table to look up to your prospects table
3.
set the lookup filter to be the account (for example, look up companies with the matching company URL)
a.
this will pull all matching prospects from that company
4.
then create a new column in your accounts table that calculates the total sum of prospect scores from the lookup column (i.e. prospects from that account)
a.
something along the lines of {{Look Up Column Name}}.records.reduce((sum, record) => sum + (record['Prospect Score'] || 0), 0)
Bo (.
·
·
Hey, thanks for reaching out Josephine! Seems like Fabian and Joe gave you some very solid suggestions! Here's a video on Lookup and one on Formula in case you'd like to know more as well.
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Channeled
APP
·
·
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!
Channeled
APP
·
·
Hi Josephine V.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: