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

How Do I add Sum(Children) at the bottom of the children rows
Hi, How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom. I usually create a parent row, then add rows beneath it, indent them and add the formula =Sum(Children) to the parent row to calculate the total. However, that structure was confusing for users, and they…
Help with Average Formulas
Hi! I am trying to calculate a 3 months, 6 months and 1 year averages of my team utilization percentage. Each team member is a row and then each month is a column. The utilization percentages are coming from other sheets. Thank you in advance!
Need Help with a Formula
I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow I've tried a few things but can't figure it out. Can anyone help?