Assign Values to Multiple Fields in If Formula

[bgdvorak]

I'm struggling with this, and here is the scenario. I have 3 fields and trying to evaluate Field1 and assign values to both Field2 and Field3

If Field1 = "Yes", then

    Field2 = "Assignment 1"

    Field3 = "Assignment 2"

end if

Is this possible in one formula statement?  I have accomplished this by using 2 different formulas, but makes my workflow a little cumbersome. 

Thanks. 

[DataNath · Accepted solution]

Hey @bgdvorak, I wouldn't have thought 2 expressions in 1 Formula tool is that bad for performance etc. However, if you are still keen to do it in one, you could use a Multi-Field Formula tool like so:

[bgdvorak]

Thank you. That worked great.