Is it possible to use Pivot to get a count of distinct values? I want to count the number of unique values in a column, but am only able to see options for SUM, AVERAGE, and, COUNT.
You would need to use a formula.
=COUNT(DISTINCT([Column Name]:[Column Name]))
Thank you for the response. I am trying to get a distinct count in one column, grouped by the values in another column, and separated out by a different column. I am trying to get a distinct count of Building IDs, based on if they are owned or leased and group those counts by Sub Region.
Currently I am getting this count by using a separate sheet to get these calculations, but as our list of sub regions grow I am trying to look for a solution that is more flexible to avoid having to manually add a new column/formula for each new sub region.
The below image is what I currently have set up in Pivot pulling information from the source sheet. I am able to get it to produce a sheet separated by lease type and grouped by sub region, but it is giving me an overall count rather than a distinct count.
I have certain single and multiple select list columns that do not have the "restrict to dropdown values only" checked on the source sheet but in Dynamic View we are unable to add in our own values if they don't exist in the dropdown. This has been extremely frustrating especially when trying to capture new values and…
With in Dynamic View's details panel is there a way you can start to type some of the drop down information to pull up that option instead of scrolling for the right one? See below 'Market' can't type. Am I doing something wrong or is this by design? If by design I vote for an update.
Hello, I am looking to leverage the Conditional Junction: Junction Match module to set a variable to ultimately decide which path to take. Taking a step back, I have 4 of the same 'When Column is Changed' triggers, which are attached to different smartsheets. Based on which smartsheet the trigger is associated with, I am…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.