Date calculation

Alex77 · 02/11/19

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 · 02/11/19

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. · 02/11/19

Well done. I like how easily that formula reads.

Mike Wilday · 02/12/19

Awesome. Glad its working for you. Happy Smartsheeting.

Date calculation

Comments

Categories