Countif

Zia Siddiqui

Zia Siddiqui ✭

04/15/21 in Formulas and Functions

Hi, what is the criteria to use in the countif formula to only count (from a range) dates in the past? Thanks

Zia

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

04/15/21

You are going to want something along the lines of...
=COUNTIFS([Date Column]:[Date Column], @cell < TODAY())

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

Formula to SUM = 0 Why?
I created a formula to sum the values in other formula columns but the return is "0". I have created other sheets with the same type of formula and the return is correct. How is the return 0 on this formula. It appears to be correct.
Label Status Dot Help
Hey all! I am trying to add the color symbol dots to align with status and I've tried so many formulas, I cannot for the life of me figure this out. Nothing crazy in this sheet, just want to align the status to the color of the dot. If Status = Complete —> Green If Status = In Discovery, In Process, In Review —> Yellow If…
HELP!!! Max Collect for Dates
I utilize Smarthsheet to manage a hospital schedule. I need to find out the last time a staff member worked. I have been playing around with Max Collect and constantly failing… #UNPARSEABLE Things to note: The Primary column shows the name of the staffer multiple times with multiple different dates under the Date Worked…