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
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 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!