Formula help to return differnt conditions

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

Find more posts tagged with

Sheets

Formulas

Reports

functionality

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.