Formula tool

[AntlRo]

Hi Everyone,

My data set looks like the below with many rows but below is just a sample: 

Name	Training Completed	Value	Email:
John Cool	Bananas	True	Johncool@email.com
John Cool	Bananasoranges	True	Johncool@email.com
Billy Joel	Bananas	True	Billyjoel@email.com
Billy Joel	Bananansoranges	False	Billyjoel@email.com

Now out of this data set I would like  the : 

-Unique name and whether all their trainings Value = True then return the value " Complete" .

- IF not all trainings True for specific unique name then return colum with the email

- then I use the email tool to email the user they have "incomplete trainings please complete" 

output would look like below(make it dynamic for any name) :   then take the email to email users some trainings are incomplete

Name	Traning completed	Value	Email
Billy Joel	Banananasoranges	False	Billyjoel@email.com

[binu_acs · Accepted solution]

@AntlRo You can add a filter tool and filter based on the Value field

[Raj]

I think this output can be directly achieved by filter tool.