Formula

Options

Hi

I need to return a status that references today between date ranges:

I have four types of statuses that should be shown:

  1. Planning,
  2. Execution,
  3. Monitoring,
  4. Closing.

Let have the following conditions:

If Today is between Start Date 1 and Finish Date 1 - Planning should be reflected,

If Today is between Start Date 2 and Finish Date 2 - Execution should be reflected,

If Today is between Start Date 3 and Finish Date 3 - Monitoring should be reflected,

If Today is between Start Date 4 and Finish Date 4 - Closing should be reflected,

The formula will be in the top row of the sheet and will have to reference several rows to determine the status.

Pls help on a formula.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!