Help

Roll up Feature Question

Topic Labels: Formulas
335 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

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")