Date Comparison

dsmartsheetuser

dsmartsheetuser ✭✭

10/25/22 in Formulas and Functions

Hi,

I am trying to do a formula where if 'Date1' is less than 'Today' then use 'Date2'.

Appreciate the help!

Thank you,

Deepthi

0 ·

Best Answer

Ryan Sides Community Champion

10/25/22 Answer ✓

Hi @dsmartsheetuser
Hi Deepthi, try this one...
=if([Date1]@row < today(), [Date2]@row)
Did that help?

Ryan Sides
Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube
Come Say Hello!
1 · Share on Facebook Share on Twitter

Answers

Ryan Sides Community Champion

10/25/22 Answer ✓

Hi @dsmartsheetuser
Hi Deepthi, try this one...
=if([Date1]@row < today(), [Date2]@row)
Did that help?

Ryan Sides
Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube
Come Say Hello!
1 · 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

Gantt View/Schedule W/out Weekends
Hello, I am making a construction schedule for one of our projects and I cannot figure out how to disable the weekends. The 'Duration' column is the one that gets manipulated. I want it in a way that both 'Start' and 'End' columns update based on the inputted duration. and 'End' columns get automatically updated based on…
Weighted Check box's
Just looking to see if there a is a better way to do this. i know i can Write a LONG IF statement to do this. i would like if Step 1 is Check Step Percent would %20 If Step 1 and Step 2 is Checked it would = 75 % if Step 1,2,3 are Checked it would = 95% if step 1,2,3,4 are Checked it would = 100% just looking to see if…
Boolean Expected
=COUNTIFS({Client Name/Planter Location}, Client@row, {Bed Plants (Early Spring)}, 1) I'm trying to match a name on a current sheet with that on another sheet; and on the other sheet, the name may appear multiple times with one or more checked boxes under Bed Plants Early spring. The results are: a box gets checked or i…