Is there a work around to capture modified by for a cell instead of the row?

Hi everyone,

I’m working with Smartsheet’s Dynamic View and I’m wondering if there’s a way to automatically enter the email of the person updating a specific cell into another cell. I only need the email to be captured when a particular cell is updated, not the entire row. Modified by will not work because that changes any time the row updates. I need capture the people changing 1 column. It could be a different person in each row. It would also work to pull the cell history into a column.

Has anyone managed to set this up or found a workaround? Any tips or guidance would be greatly appreciated!

Thanks in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!