Formula question
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.
Answers
-
Can you provide some sample outputs and maybe more context on how you are using this data?
-
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)
-
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?
-
Yes, that is correct.
It will be on a separate sheet
-
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")))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!