Greater than a "Date" argument

yashin11

yashin11 ✭✭

01/09/24 in Formulas and Functions

Hi,

Does anyone know how to define a Greater than a "Date" argument in an IF statement?

For Example: = COUNTIFS( Sales:Sales, [Sold Date]:[Sold Date], 12/20/23)

0 ·

Answers

Kelly Moore Community Champion

01/10/24

Hey @yashin11
Try this
= COUNTIFS( Sales:Sales, [Sold Date]:[Sold Date], @cell>12/20/23)
Will that work for you?
Kelly

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

Count value in columns
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up this formula? I tried several one but not found the best. The result will be shown in the blue column, this will be 0, 1, 2,…
Formula Question
Needing help creating an average formula that cross-references sheets. I have created a metrics sheet for this task. I need a formula that calculates the average pending days an item has been open, with an assigned task level of '1', for a specific type of category, that is specifically assigned to an individual person.
Logic formula to return a value on another sheet based on two search criteria
I am trying to develop a formula that will return a request ID # to an invoicing sheet. The source sheet includes the request ID # and two columns with the criteria I want to be met (Lot Charge Fee, Ready to Invoice). I want the request ID # to only show up on the invoicing sheet if the following criteria is met: Lot…