I created a zap that will automatically create a spreadsheet row whenever the due date of an asana task is updated. Now, I want the original due date to be recorded as well as the new due date. How will I do that? I hope someone will be able to assist me. Thank you
+11Hi there
I’d have thought that yo’d need to use a Lookup Spreadsheet Row action to record the original due date. That action has the ability to create a new spreadsheet row if one isn’t found. So if the Zap triggers for a task that has a due date set and it’s not in the spreadsheet already then that due date would be used for the Original Due Date column.
Then to handle cases where a new due date is set you’d have a Filter in the same Zap, that checks to see if an existing row was found (the Zap Search Was Found Status field will contain a value of true if it finds a row and false if it doesn’t). And if it was, then an Update Spreadsheet Row action would add the new due date value to the New Due Date column for that row.
Hope that helps to get you pointed in the right direction. If you run into any issues on that or have further questions just let us know!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
