And If But Formula

Susan van Niekerk

Hi Brain Trust

I am trying to build a formula that will return a count when 2 set of criteria align

When Approval type is "Approvals" and Status is "Complete" count the relevant year in Financial Year

IE - I want to know how many project "completed" projects we have for "Approvals" in 2023, 2024, ect ect

Paul Newcome

You would use a standard COUNTIFS for this:

https://help.smartsheet.com/function/countifs

.