Conditionally Copy "Modified By" value to another row cell

ternst
ternst
edited 11/05/24 in Smartsheet Basics

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?

Best Answer

Answers