IF Statement with Dates
John Littler
✭✭✭✭
Need help with a nested IF statement?
Please see attached, I need to automatically change the ACTUAL DATE column by adding the number of days in the DAYS column to the ESTIMATED DATE column based on the TEAM column?
Any help is appreciated!
Thx
Best Answer
-
if I am understanding correctly you would do something like
=IF(TEAM@row = "DOP", [Estimated Date]@row +90 ,IF(TEAM@row ="IOP", [Estimated Date]@row+60,IF(TEAM@row = "LEAN", [Estimated Date]@row+30
Answers
-
if I am understanding correctly you would do something like
=IF(TEAM@row = "DOP", [Estimated Date]@row +90 ,IF(TEAM@row ="IOP", [Estimated Date]@row+60,IF(TEAM@row = "LEAN", [Estimated Date]@row+30
-
@Kimberly Loveless ... worked like a charm! Thanks so much.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!