Is there a way to create an automation to change a cell to a formula?


I'm trying to copy data from column to another, but only if certain conditions are met (i.e. if a separate column is checked or has a specific drop-down selection). I tried creating an automation with conditions that writes a formula to copy the cell into the column I want, but it adds a ' to the beginning of each function so the formula is useless. Is there a way to get around this without me learning how to expertly use if statements or manually changing cells?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!