Add a Formula to a Cell Using Automations
Is it possible to add a formula to a cell using an automation? I attempted to do this using the Change cell value action, but it only adds the formula as text. The sheet does not recognize it as a formula even though I did start it with an "=".
I'm trying to populate the value of a cell with data from a cell in the same row of another column based on the selection from a dropdown in still another cell in the same row. The problem I have is that there will be more than 60 potential columns from which I may need to populate. This would make for a very long, and difficult to maintain, nested IF statement, so I'd prefer to avoid this route if possible.
Thanks for any help or suggestions.
Help Article Resources
Check out the Formula Handbook template!