Use Zapier to populate a column based on the date a comment was added
I am trying to use Zapier to add the date to a row that reflects when a comment was last added in that row.
I thought I got it up and working, but ran into an error when I moved from testing to implementation.
I used the "New Comment in Smartsheet" trigger and returned the Results Modified at by referencing the "Parent ID" as the Row ID. The problem is, the Parent ID does not adjust based on new rows/comments, so once implemented it would not return a usable row ID.
Zapier support told me to try and use the Row Updated trigger as that allows the Original ID field to be pulled in for the Row ID.
Anyone know how to make this zap?
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
Help Article Resources
Check out the Formula Handbook template!