Count NOT Blank (Joining) + Certain Region
All,
I am creating a formula on a metric sheet to COUNT NOT BLANK columns (range of several) AND if meets a certain region. I tried a few. Any tips?
=COUNTIF(ISBLANK(join{([SALESFORCE Data Error: Late Fee % or Grace Period]}:{[YARDI: Timing Charges Not Billed to Ledger]}, 1, Region@row)
Answers
-
Is the region a specific column?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yes, named "Region"
-
Try something along the lines of...
=COUNTIFS({Region}, Region@row, {First Column}, <> "", {Second Column}, <> "", {Third Column}, <> "", .....................................)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
ah, it (almost) worked!
I want to count if ANY of the columns are NOT Blank. Where would I add that?
=COUNTIFS({Region}, Region@row, {Lease Move in Log Range 2}, <>"", {Lease Move in Log Range 3}, <>"", {Lease Move in Log Range 4}, <>"", {Lease Move in Log Range 5}, <>"", {Lease Move in Log Range 6}, <>"", {Lease Move in Log Range 7}, <>"", {Lease Move in Log Range 8}, <>"", {Lease Move in Log Range 9}, <>"", {Lease Move in Log Range 10}, <>"", {Lease Move in Log Range 11}, <>"", {Lease Move in Log Range 12}, <>"", {Lease Move in Log Range 13}, <>"")
-
It NEEDS to meet the "region" criteria but IF ANY of the other fields are NOT Blank, I want to count....
the ISBLANK at front is not working :(
-
Ah. Ok. I misunderstood. Thought you meant that you wanted to count for rows where ALL columns were not blank.
It will be easiest to insert a column on the source sheet (checkbox type will work well) and use a formula to check the box for any rows where there is a "non-blank" cell across your columns.
=IF(COUNTIFS([First Column]@row:[Last Column]@row, @cell <> "") > 0, 1)
Then the cross sheet formula would be as straightforward as
=COUNTIFS({Region}, Region@row, {Checkbox}, 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Ah, that will do it! thank you, Paul!
-
Happy to help! 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!