comparing dates

Options

Alta

Alta ✭✭

08/08/22 in Formulas and Functions

I want to compare dates so that if the date of one column is within 3 days of the other date, "pass" goes into a new column, otherwise it prints "fail"

0 ·

Answers

Brent Wilson Community Champion

08/08/22 edited 08/08/22

@Alta
=IF(ABS( [Date1]@row-[Date2]@row)<=3, "Pass", "Fail")

Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.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

Help with using index and match to reference other sheets.
I am trying to create logs for our operators to use on two different operations. One operation always happens before the other operation. So operation 2 will reference the sheet of operation 1 and pull data over and have it all end up on the same line. This was working well until I tried to make a new sheet. Now when I…
Time Conversion from Decimal Back to HH:MM
I have successfully converted my Start / End time columns over to decimal format so I can get the Total Outage Time on my sheet. However, I need to be able to convert it back from decimal format to HH:MM time format just for display purposes. I keep the wrong number of minutes (hours are fine). Can anyone assist? I have…
Text in cell to translate to Number if different cell
I am trying to write a formula that when Client Name says Weekend Stay to populate $150 in the Rate of Pay column.