Formula for "Starting Next" and "Ending Next"

Options

Hello!

I'm struggling with a formula.

I have a Smartsheet template of a Simple Project Portfolio, and within the dashboard display it has a feature for the project "Starting Next" and the project "Ending Next". However, there must be something wrong because it shows just the projects with the earliest start and end date (in the past).

I'm interest on having displayed the project that starts closer in the future, from today onwards, that don't have the status of "In progress" or "completed". And also I want displayed the project that will end sooner in the future, from today onwards, that don't have the status of Delayed or Completed.

Can someone help me to generate the right formula to display this? I'd like to collect the projects "Starting Next" and "Ending Next" from my project sheet.

I have a column with:

  • Start date
  • Status
  • End date
  • Project
  • project Code

Thanks!

Audry

Best Answer

Answers