Conditionally Copy "Modified By" value to another row cell

ternst

An update to a column called, "FOO", should trigger an event where the contents of "Modified By" are copied to a column called, "BAR".

Steps.
1. I change the contents for "FOO" from 'a' to 'b'.
2. "Modified By' changes to my email (the usual automated way)
3. My email is copied over to "BAR"
**If a field other than "FOO" changes, it doesn't affect "BAR".

This doesn't seem possible via an automation?

Paul Newcome

Not directly via automation, but I did develop a way to do this that uses an automation. The basic idea is that you set up a helper text/number column with a formula that simply replicates the [Modified By] column data.

=[Modified By]@row

Then you set up a copy row automation to trigger when [FOO] changes and copy the row to another sheet (this captures static data in that helper column).

Finally you would use a formula with cross sheet references such as INDEX/MATCH to pull the static data from the helper column back into the first sheet.

The below thread is for the date/time stamp, but it is the same idea.

https://community.smartsheet.com/discussion/63561/date-time-stamp-option

Paul Newcome

Not directly via automation, but I did develop a way to do this that uses an automation. The basic idea is that you set up a helper text/number column with a formula that simply replicates the [Modified By] column data.

=[Modified By]@row

Then you set up a copy row automation to trigger when [FOO] changes and copy the row to another sheet (this captures static data in that helper column).

Finally you would use a formula with cross sheet references such as INDEX/MATCH to pull the static data from the helper column back into the first sheet.

The below thread is for the date/time stamp, but it is the same idea.

https://community.smartsheet.com/discussion/63561/date-time-stamp-option

ternst

Thanks @Paul Newcome for this great advice!

Paul Newcome

Happy to help. 👍️