Use Zapier to populate a column based on the date a comment was added

Hi everyone,

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!

PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!