Formulas in the automation workflows

I track both client addresses and project addresses in my sheet. I have a helper column that tracks whether the two are the same. I input all new project through a form, so I can't put an IF/Blank formula directly in the project address cell because if I enter in a project address, the next line breaks the formula.

I'm trying to find a way to automatically copy the client address into the project address column if I confirm they are the same in my helper column. However, the workflow automation doesn't let me use a formula. Below is a screenshot of what I'm trying to do, but it just copies the formula as text.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!