Date calculation
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?
Comments
-
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
-
Well done. I like how easily that formula reads.
-
Awesome. Glad its working for you. Happy Smartsheeting.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives