Formula help to return differnt conditions

David Clunie

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

Mark Cronk

Hi @David Clunie ,

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

Mark Cronk

Hi @David Clunie ,

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