Provide an Automation option under Change Cell Value to "Copy value from another cell in the same row".
This is necessary when managing data with data shuffle and cross references. It is the only way to automatically capture data snapshots when certain conditions are met, or one-time replace data when certain conditions are met.
