Skip to main content

Hello,



I have a master table with a column linked to subtasks from another table with statuses (launched, in progress, etc). In my master table, I’m trying to roll up all the unique values and if they’re not ALL ‘launched’, it should spit out ‘Incomplete’ otherwise spit out ‘complete’. Is this possible?



Thanks!

Hey Jane,



Welcome !



The way to do this is to:





  1. Use ARRAYUNIQUE(Values) function in your Roll up field so it will display only the unique values.


  2. Create another formula field with the following formula to display the final complete/imcomplete status: IF(Status = "Launched", "Complete", "Incomplete")



Reply


Terms & Conditions