Date calculation

Alex77

I am trying to use an Excel date-related calculation in Smartsheet and I'm having trouble translating it into Smartsheet. Any thoughts on the situation below? 

Column A (Deadline) is manual entry of Deadline date - no issue there.

Column B (Due in Next 60 Days) is supposed to return "TRUE" if the Deadline date in the row in Column A is not empty and is a date within the next 60 days of today (otherwise it returns FALSE). The formula used in Excel for this works, but I cannot get a similar formula to work in Smartsheet. The Excel formula that works is:

 =IF([@[Deadline]]<>"",AND([@[Deadline]]>TODAY(),[@[Deadline]]<=TODAY()+60),"")

Thoughts? 

Mike Wilday

Try this one: Just took what you provided and massaged it for smartsheets. 

=IF(AND(NOT(ISBLANK(Deadline@row)), Deadline@row > Today(), Deadline@row <= Today(60)), "True", "False")

If the deadline is not blank, Is greater than today, and <= Today +60 days, then it will display as True, otherwise, False

 

Mike L.

Well done. I like how easily that formula reads. 

Mike Wilday

Awesome. Glad its working for you. Happy Smartsheeting.