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

  • Paul McGuinness
    Paul McGuinness Overachievers

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!