Hi, I need help in creating a formula to write referral data to a new column. In the Dataset we have Columns A:C and I need to create a new Column D (Referred By) based on this logic:
Where there are common engagement ID's (In this case 1234 or 5678) if 'inherited Sale' = True then set Referred By to Full Name.
Thank you in Advance!