Need help making this formula work
I want to add to this formula that if Entered in Oracle Date is Blank, INCOMPLETE will populate in the First Shift Entered On or Before First Shift field. My current formula: =IF([Entered in Oracle Date]@row <= [First Scheduled Shift]@row, "YES", "NO"). How can I add what I am looking for?
Answers
-
You'll want to nest your current IF formula as the negative condition of an IF formula checking for a blank cell in "Entered in Oracle Date," using the ISBLANK function.
=IF(ISBLANK([Entered in Oracle Date]@row), "INCOMPLETE", IF([Entered in Oracle Date]@row <= [First Scheduled Shift]@row, "YES", "NO"))
In English: If it's blank, enter "INCOMPLETE," if it's not blank, evaluate the date to choose YES or NO.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you so much! I was messing up the parenthesis when I tried to do it. I appreciate your help Jeff.
-
Glad I could help. Smartsheet's color-coded parentheses when building formulas can help a lot! When in doubt, for every IF(, make sure there's a ) at the very end of the formula, and that for each ( inside an IF, there's a ) before the next IF.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 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
Check out the Formula Handbook template!