IF Statement with Multiple YES or No to Output Text

[kenrossco]

I have multiple Yes/No Statements and am trying to figure out an IFS Statement that will help me out put a unique Status. Any help is appreciated.

If [Is X Started] is yes - Status will be "Started"

If any of the below are toggled No or then anything Yes or No will have the  Status as "Deficient"

If all are togged Yes then Status will be "Complete"

[Is it Labelled? ]
[Spiral Installed?]
[All Restraints installed?]
[All Seals Installed?]
[Gravel in Base Installed?]
[Trace Wires Bonded Together?]
[Vault Grounded]
[Site Clear of Debris?]
[Vault Lid Fastened with Bolts?]
[Site Restoration Complete?]
[Is X Complete]
[No X Missing]

[dbaum]

I don't understand what you mean by "or then anything Yes or No".

Maybe the following approximates what you need.

IFS(
  [Is X Started], "Started", 
  OR(NOT([Col1]), NOT([Col2]),...), "Deficient", 
  AND([Col1], [Col2],...), "Complete"
)

[Joseph_Seddik]

App formula for column Status:

IFS(
  AND(
    [Is it Labelled? ],
    [Spiral Installed?],
    [All Restraints installed?],
    [All Seals Installed?],
    [Gravel in Base Installed?],
    [Trace Wires Bonded Together?],
    [Vault Grounded],
    [Site Clear of Debris?],
    [Vault Lid Fastened with Bolts?],
    [Site Restoration Complete?],
    [Is X Complete],
    [No X Missing]
  ), "Complete",
  [Is X Started], "Started",
  TRUE, "Deficient"
)