Hi, I would like to know if it is possible to have Zapier automatically update the date of last entry on my sheet. I have a book for Sales forecast, it is my self made CRM. I have a sheet where I keep track of my leads and I keep on updating it everytime I do something like sent an email, a follow up or contacted them on LinkedIm. So, everytime I write notes on the notes section of my sheet to update what I did, I need Zapier to update the date to the day and time I updated the notes section. This will help me to know if I need to follow up on that lead. Is it possible? how to do it?
Question
Microsoft Exel log, updating dates of last entry
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Help link for using system generated timestamps in Zap steps: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field
+14- Zapier Orchestrator & Solution Partner
If you use an app like Airtable instead of a spreadsheet, there are specific field types that will track the records “Last Modified Date/Time”.
Info about Airtable field types: https://support.airtable.com/docs/supported-field-types-in-airtable-overview
+6- Zapier Staff
Hi
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.