Hello,
I want to import data, to my contacts module (to trigger a workflow on a field update). I have a csv available which has a contact email and a list of dates in chronological order. One email could have multiple dates. When uploaded, the dates will update a date field against the contact and trigger a workflow.
Email | Date |
a@a.com | 01/03/203 |
b@b.com | 03/03/203 |
a@a.com | 05/03/2023 |
Is there a way in Zoho to upload this CSV and have it only use the last date of an email address? I am also exploring a formula in excel to do this. But I thought I would ask here too.
Thank you
Alex