I need a formula that allows the following:

HYG_Support

If Modified B has “automation@smartsheet.com” then use Modified By column data but if Modified B is anything else place Modified B data in New Modified By column.

Amber Eakin

Hello, @HYG_Support !

Try this: =IF([Modified B]@row = "automation@smartsheet.com", [Modified By]@row, IF([Modified B]@row <> "automation@smartsheet.com", [Modified B]@row, [Modified By]@row))

Let me know if it works for you!