Forum Discussion

Socrates's avatar
Socrates
Frequent Visitor
6 years ago
Solved

Set overall status if all tasks completed

I have a table where multiple people could be assigned to one project, but even if one person's part is complete the whole project is still live until everyone is done. For instance:   Project I...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Socrates - Should be something like:

    Column =
  VAR __Table = SUMMARIZE(FILTER('Table',[ProjectID]=EARLIER([ProjectID])),[Status])
RETURN
  IF(MAXX(__Table,[Status])="Completed" && COUNTROWS(__Table)=1,"Completed","Live")
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Socrates - Should be something like:

Column =
  VAR __Table = SUMMARIZE(FILTER('Table',[ProjectID]=EARLIER([ProjectID])),[Status])
RETURN
  IF(MAXX(__Table,[Status])="Completed" && COUNTROWS(__Table)=1,"Completed","Live")