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 ✭✭✭✭✭✭

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

IF formula with multiple options
Good morning- Wondering if someone might be able to help me with this. I have a dropdown list column that has three options. If option A is selected, I want to automatically populate another column in the sheet with a specific message, but if option B is selected, I want to populate that same column but with a different…
Index Join Collect - gather list
I want to create a formula that gathers a list of zones by identifying the area. Column A is the area, Column B are all the zones that are under each area. In the related form, the person enters Column A area and adds a zone to Column B that is under that particular area. As the list of zones builds with each form issued,…
Find if any string from a list of strings is present in a cell
Hi I have a sheet with a column "List of Tests" that has a list of test codes, e.g. row 1 = T101, row 2 = T102, row 3 = T103; this same sheet has another column "Selected" that has a check mark to show whether or not the test was selected. A second sheet has a column that has one or more tests listed called "Applicable…