Can an automation action copy data from one cell to another in the same sheet?

Hello, everyone!

I am helping my boss with a new template to manage our projects. I need an automation that copies data from one cell to another within the same row based on two conditions. Without more context this will sound confusing, but I will try my best to explain.

If one column is not blank, and the other column is marked "delivered" then I need the "Quoted Price" to copy into the "Final Price." I am not sure if this is possible, but if it is, does anyone know how to complete the automation?

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!