How to apply a priority countif formula to specific rows based on cell criteria?


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

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    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 <> "")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!