Nested IF statement with date comparison
I am either getting a #UNPARSEABLE error or #INCORRECT ARGUMENT with my formula. I am trying to compare two different date columns (Posted Date) or (Last Reviewed) against another date column (Deadline) to indicate a Yes or Review Needed. One of my columns (Last Reviewed) could be blank because it has been reviewed since posted. I need Yes if the Posted or Last Reviewed date is greater than the deadline, Review Needed if not or blank. I have tried a couple of versions.
=IF(Deadline19 > [Posted Date]19, "Review Needed", IF(Deadline19 > [Last Reviewed]19, "Review Needed"), IF(Deadline19 < [Posted Date]19, "Yes"), IF(Deadline19 < [Last Reviewed]19, "Yes"))
=IF(Deadline18 > [Posted Date]18, "Review Needed", "Yes", IF(Deadline18 > [Last Reviewed]18, "Review Needed", "Yes"))
Answers
-
I am having a little trouble following what exactly you are trying to accomplish (very long day - my apologies), but your first formula seems like it should do the trick with a few syntax corrections. It looks like it just has a couple of misplaced parenthesis.
Here it is with the parenthesis adjusted to follow proper syntax:
=IF(Deadline19 > [Posted Date]19, "Review Needed", IF(Deadline19 > [Last Reviewed]19, "Review Needed", IF(Deadline19 < [Posted Date]19, "Yes", IF(Deadline19 < [Last Reviewed]19, "Yes"))))
-
Paul -
I have two date columns of when either a document was created (then posted) on our website or was subsequently revised/reviewed and then the new version posted on the website. I need to find out the ones that either one of those date columns is before my deadline review date of 01/01/2018, so I can see if they need reviewed or not.
-
I think I just answered my own question - I was overthinking it. I can have my last reviewed and post dated be the same. Then I can just compare the two columns.
Thanks Paul!
-
Haha. No need to thank me. Apparently I didn't help much. You figured it out on your own. If you still need help, let me know. I am going to grab some much needed coffee, so hopefully I won't be so slow on the uptake here before too long. Hahaha.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!