# Formula help to return differnt conditions

Hi

I am after help in developing a formula to look for certain conditions. I require the highlighted cell in blue perimeter to record certain condition if a condition is true from the 5 cells below.

If all cells return Completed then return "Completed"

If all cells return Not Started, then Return "Not Started"

If all cells return mixed conditions, then return "In Progress"

I have the following fields within the column as dropdowns.

Not Started

In Progress

Waiting For Checks

Checks in Progress

Completed

• ✭✭✭✭✭✭

You may need to adjust this based on where you're placing the formula and how many rows are below it, but it will give you the general idea:

=IF(COUNTIF(staus2:status6, "Complete")=5, "Complete", IF(COUNTIF(staus2:status6, "Not Started")=5, "Not Started", "In Progress"))

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

You may need to adjust this based on where you're placing the formula and how many rows are below it, but it will give you the general idea:

=IF(COUNTIF(staus2:status6, "Complete")=5, "Complete", IF(COUNTIF(staus2:status6, "Not Started")=5, "Not Started", "In Progress"))

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!