Need Help With COUNTIFS OR Formula.

SmarsheetNewb

=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], "In Progress")

That formula is to count the number of cells that have "Now (1/1/24-5/31/24)" in the Timeline Prioritization column while also have "In Progress" in the System Status column. Based on the provided screenshot, the number would be 3.

I would like to amend the above formula by adding an OR so that the formula counts the number of cells that columns that have "Now (1/1/24-5/31/24)" in the Timeline Prioritization column while also having either "In Progress" or "Pending Start" in the System Status column. Based on the provided screenshot, the number would be 4.

Nic Larsen

Try:

=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], OR(@cell = "In Progress", @cell = "Pending Start"

Nic Larsen

Try:

=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], OR(@cell = "In Progress", @cell = "Pending Start"

SmarsheetNewb

https://community.smartsheet.com/discussion/comment/422915#Comment_422915

Thank you Nic. That worked.