https://community.hubspot.com/t5/APIs-Integrations/Matching-mapping-line-items-to-deal-information/m-p/607297#M52162 <P>Sure, I use Zappier to grab all line items into one worksheet and deals into another. Then I have created a sheet called dashboard where I combine the two using the deal ID. The formula that works for me is a simple SUMIF.&nbsp;</P> Mon, 04 Apr 2022 14:47:52 GMT RDuric 2022-04-04T14:47:52Z