If there are duplicates for a corresponding Primary Column, I want computation to appear only once

Options

Hi,

I am trying to find, how many Promotions are for a particular item for a particular Start Date.

Example:

Promotion || Total Number of Promotions for Start Date || Start_Date

Bacon || 1 || 2/4/2020

Chocolate || 3 || 3/14/2020

Chocolate || 3 || 3/14/2020

Chocolate || 3 || 3/14/2020

Chocolate || 1 || 2/14/2020

Above table has Promotions each entered Multiple times, as different people are inputting the date based on other criteria. However, I am looking to have the duplicates removed. Example:

Promotion || Total Number of Promotions for Start Date || Start_Date

Bacon || 1 || 2/4/2020

Chocolate || 3 || 3/14/2020

Chocolate || 1 || 2/14/2020

How do I achieve this?

Thank you,

Deepthi

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!