I need a formula that allows the following:

Options

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


Answers

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    edited 04/13/23
    Options

    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!

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!