Help

Re: Roll up Feature Question

493 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jane_Lee
4 - Data Explorer
4 - Data Explorer

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
Noamsay
6 - Interface Innovator
6 - Interface Innovator

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