Formula question

Leighmercado

Hello all!

Can you please help in writing a formula in smartsheet that will give me column B against column C and column D? This is just a sample but it came from a large data set.

so if COlumn B is 111-22-333, it is owned by Column A and described as column D.

Paul Newcome

Can you provide some sample outputs and maybe more context on how you are using this data?

Leighmercado

im trying to create a dashboard that will show how many in column B is assigned to column A that are top kits (column D)

Paul Newcome

So you want a count of something. It sounds like maybe a count of distinct values in [Column B] for [Column A] where [Column D] is "Top Kit"?

Is this going on the same sheet as is pictured above or a separate sheet?

Leighmercado

Yes, that is correct.

It will be on a separate sheet

Paul Newcome

Ok. In that case your formula is going to look something like…

=COUNT(DISTINCT(COLLECT({Column B}, {Column A}, @cell = "John Smith", {Column D}, @cell = "Top Kit")))

Leighmercado

thank you for the help @Paul Newcome ! :)

Paul Newcome

Happy to help. 👍️