Hi there! Had a wonderful talk with a Pro Support the other day, and he helped me write an incredible formula for counting "Left to Sell" value on sales items our team is selling. However, I noticed after the fact that it is counting each item as 1 sale, and there may be some sales that cover multiple items but should only count as 1 sale.
For example, in the screenshot below, there is a "-1" value in the # Left column because # Sold is higher than it should be:
This is because # Sold is referencing the following sheet:
and counting each separate line as a unique sale. These three I've outlined are for the same "Domain Name" running at various dates throughout 1 week.
I hope I'm explaining this right. But essentially, I need to remove duplicate entries from this formula that is in # Sold column:
=COUNTIFS({Paid Placements - Placement Page}, [Placement Page]@row, {Paid Placements - Start Date}, >=Date@row, {Paid Placements - Start Date}, <=[End Date]@row)
Is there a way to do that in the formula?