"IF" function question - Urgent if possible

I have a sheet where i am tracking multiple different tasks for completion. i am attempting to create an (Overall status) once a few key items are marked completed, and or box is checked.

Can someone explain how this can be done?

Example: EDI setup-completed, testing successful check box checked, contracted check box checked

Find more posts tagged with

Formulas

Support

functionality

Accepted answers

All comments

Paul Newcome

Are you able to provide more detail as to your setup and process? Are you able to provide a screenshot for context with sensitive/confidential data removed, blocked, or replaced with "dummy data" as necessary?

Based on your initial description, it should be possible.

Daniel Pochop

I was able to figure out the following so far: =IF(AND([EDI Status]62 = "Complete", [Procurement Status]62 = "Complete"), "All Tasks Complete", "In Progress")

Im trying to see how to add in if a status shows cancelled or NA that if defaults to a certain key, if that makes sense.

Paul Newcome

I'm not sure I follow. Can you provide an example?

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.