# Solve math formula that is currently text in a cell using a button? (trying to make a calculator)

**URL:** <https://connect.superhuman.com/t/solve-math-formula-that-is-currently-text-in-a-cell-using-a-button-trying-to-make-a-calculator/24528>\
**Category:** Ask the Community\
**Created:** [July 13, 2021, 5:23am UTC](https://connect.superhuman.com/t/solve-math-formula-that-is-currently-text-in-a-cell-using-a-button-trying-to-make-a-calculator/24528 "2021-07-13T05:23:57Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\
**Post date:** [July 13, 2021, 9:20am UTC](https://connect.superhuman.com/t/solve-math-formula-that-is-currently-text-in-a-cell-using-a-button-trying-to-make-a-calculator/24528/2 "2021-07-13T09:20:56Z")

</div>

With some black magic, everything’s possible 🙂

https://coda.io/embed/zziQAJd8UX/_su9dH?viewMode=embedplay&hideSections=true

It’s not obvious though, and not a recommended solution. This takes a button, extracts its code and replaces a piece of that code with the expression. Then creates an Action object out of that new adjusted code and sets it on another button. Please mind that the code uses slightly different notation than Coda formulas, e.g. you cannot reference rows and columns like you’d do in Coda formula language. For literal numbers it works though.

---

_[View the full topic](https://connect.superhuman.com/t/solve-math-formula-that-is-currently-text-in-a-cell-using-a-button-trying-to-make-a-calculator/24528)._
