Condition on the List

For this I am assuming the second #2 (#3?) should result in "Completed"?  If so:

a!localVariables(
  local!list: {"Start","Start","Start"},
  local!union: union(local!list,local!list),
  
  if(
    local!union="Start",
    "Start",
    if(
      local!union="Completed",
      "Completed",
      "In Progress"
    )
  )
)

Hey Chris, I think it should be started only if all the statuses are started else it will be In-Progress.

a!localVariables(
  local!statuses: { "Completed", "Completed", "Completed" },
  if(
    union(local!statuses, local!statuses) = "Start",
    "Start",
    "In-Progress"
  )
)

Unknown said:

Hey Chris, I think it should be started only if all the statuses are started else it will be In-Progress.

My logic is under the assumption that the initial post intended to indicate {"Completed","Completed","Completed"}="Completed", instead of "In Progress" - we will need the OP to confirm.

Correct, Actually it will be like the way you said but don't know what OP is looking for.

For a more condensed version of my solution, assuming this is the intended result:

a!localVariables(
  local!list: {"Start","Start","Start"},
  local!union: union(local!list,local!list),
  
  if(
    count(local!union)>1,
    "In Progress",
    index(local!union,1,null)
  )
)

For a more condensed version of my solution, assuming this is the intended result:

a!localVariables(
  local!list: {"Start","Start","Start"},
  local!union: union(local!list,local!list),
  
  if(
    count(local!union)>1,
    "In Progress",
    index(local!union,1,null)
  )
)