Formulas

[rdeguzman]

Hi There,

I am looking to see if someone can help me with a formula. That will allow me to add lines together if needed.

If the work ID number is the same, then I want to make a column called "Partners" where it adds the all the possible partners together.

I cannot get the IF statement to work, is there something im missing. 

To be honest, I am terrible at IF Statement creation.

IF !IsNull[Partner] AND [Work ID Number] = [Row-1:Work Record ID]
THEN [Dependent Name] + [Row-1:Dependent Name]
ENDIF

[john_miller9 · Accepted solution]

@rdeguzman I took a stab at what I believe you're looking for.  If this is not correct, could you provide an example of the desired output?  Thanks,

jm

[rdeguzman · Accepted solution]

That worked perfectly. Didnt even think of that option.

Thanks!