And If But Formula

Susan van Niekerk

Susan van Niekerk ✭✭✭✭

02/03/25 in Formulas and Functions

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

0 ·

Answers

Paul Newcome Community Champion

02/03/25

You would use a standard COUNTIFS for this:
https://help.smartsheet.com/function/countifs
.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

IF and BLANK nesting formulas
I am trying to use an IF statement in the approved column that says "If status is requested, return PIPELINE, all other statuses return APPROVE, unless it's blank then leave the cell blank". Everything I try returns #UNPARSEABLE. I had it working but someone messed with my sheet and now I can't get it back! Help :)
Formula Help
I currently have a formula to Join and Collect Date from multiple rows in Smartsheet but it is displaying the data multiple times in the single cell, I need the formula to only show each unique ID once but can't seem to get the results to work. Every time, I adjust the formula below, to try and incorporate a new function…
Index Match formula not working properly
I'm trying to use an Index Match formula to pull data from another sheet based on matching an order number (T Scan column). For some reason it works perfectly when the order number is 8 characters. Any order number less than 8 characters returns #NO MATCH. I even tried adding additional characters to one on this sheet as…