IF, Then Formula
I need to figure out how to put together an "IF, Then" formula based on dates & selections from a drop down.
One column is "Project". There is a drop down list of projects to choose from.
The next column has the "Live Date" of the project.
The column after has the "Kick Off Date" for the project.
If the number of days from kick-off to live date varies per project, how do I make Smartsheets auto populate the Kick-Off Date once the Project & Live date are entered? Let's say our "x project" has 25 days needed from Kick Off Date to Live Date.
I am assuming it would need to be something like =IF(Project@row="x project", [Kick Off Date]@row=[Start Date]@row - 25
This is wrong obviously, so I'd love any help!!
Answers
-
HI @sver
Will the days duration (25 days in your example) before start date be the same for all projects or will each project be different?
If different, are those days stored in a column on this sheet or another sheet?
The more detail and visuals you can provide the more likely someone will be able to help.
Thanks
Paul
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!