IF AND statement using TODAY function also
Hello Community,
I am trying to get "Yes" to appear within a column in the event that a checkbox type column is checked, and the date found in a date column is 7 days old, or older. Here is what I have at the moment:
=IF(AND((Complete2 = 1, "Yes", ""), [Due Date]2 > TODAY() - 7), "Yes", "")
Any help with this would be appreciated, thanks!
Comments
-
Give this a try...
=IF(AND([Complete2] = 1, [Due Date]2 > TODAY() - 7), "Yes", "")
-
Hey Paul,
Thanks for the reply. That didn't seem to work for some reason.
Here, I've attached a screenshot of the sheet I'm working on--it's fairly simple. I'm just trying to achieve the Archive column populating as a "yes" when the task is complete *and past the due date for the task.
Thanks!
-
Ah. Ok. The screenshot helped. Thry this one instead...
=IF(AND(Complete@row = 1, TODAY() - [Due Date]@row >= 7), "Yes", "")
-
Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5].
EXCELL
=IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d")))
SMARTSHEET
=IF([Column5]2="","",IF([Column5]2<TODAY(),-DATEDIF([Column5]2,TODAY(),"d"),DATEDIF(TODAY(),[Column5]2,"d")))
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives