Counting physical inventory while removing duplication...

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Counting physical inventory while removing duplication...

I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is, some of these Unit Numbers have multiple work orders which are listed on another column, and a total work order count does not represent how full our facility truly is.


I was thinking of using:

=COUNTIFS(DISTINCT([Unit #]:[Unit #]... but how do I complete a DISTINCT count formula while only considering those On-Site "Green" indicated cells???


Answers

  • Hello Drew

    Can you please phrase your question in the following manner so I can try and help you asap! :)

    "I want to count all the values of Column X which are [specify all your criteria here]"

    regards

    Nasir (Zealvert)

  • I'm also interested in this, as I have a similar situation, but with just one criteria.

  • @[email protected]

    I want to count all the values of Column “Job #” which have a green dot (On Site / Off Site column) in their corresponding row.

    *Please include in the formula, if possible, the removal of any duplicate “Job #” data.*

Sign In or Register to comment.