How to apply a priority countif formula to specific rows based on cell criteria?
Hello,
I am using the following formula in a priority column to maintain ranking number when filtering my sheet. I would like to apply this formula to the rows based on criteria in my "Open, Backlog, Closed" column. For instance, if a closed is selected for a row, i do not want the formula to apply to that row.
=COUNTIFS([Project Name]$1:[Project Name]@row, OR(@cell = "", @cell <> ""))
Any help would be appreciated.
Best Answer
-
Check if this meets your requirement,
=IF([Status Column Name]@row <> "Closed", COUNTIFS([Status Column Name]$1:[Status Column Name]@row, <>"Closed", [Project Name]$1:[Project Name]@row, OR(@cell = "", @cell <> "") ) )
Answers
-
Do you mean to say that for anything other than "Closed" apply the formula? If yes, then you can write it this way,
=IF(HAS([Status Column Name Here]@row, "Closed"), "", COUNTIFS([Project Name]$1:[Project Name]@row, OR(@cell = "", @cell <> "")))
-
Hi @Sameer Karkhanis - that's exactly what I am aiming to do - and thank you for this. This formula get's me closer. IT does not number the rows with a closed status, but numbers the other rows as if the closed rows are not being skipped.
Thoughts?
-
Check if this meets your requirement,
=IF([Status Column Name]@row <> "Closed", COUNTIFS([Status Column Name]$1:[Status Column Name]@row, <>"Closed", [Project Name]$1:[Project Name]@row, OR(@cell = "", @cell <> "") ) )
-
It works! Thanks so much for your time. Big help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!