Can an automation action copy data from one cell to another in the same sheet?
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?
Help Article Resources
Check out the Formula Handbook template!