Creating a Calculator

Options

Hi All -

I'm trying to create a calculator in SmartSheets. I'm envisioning it as a pseudo GUI that leverages data from different sheets that we've populated, whereby we input values into this calculator, and it calculates based on predefined equations. There's ways to get close to it through a form or directly in a sheet, but I'm looking for something a little more centralized/with an interface of sorts where we can see the results change on screen & in real-time.

I've done a fair amount of Googling and haven't been able to come up with anything. Is there some sort of API, APP, etc. that I can leverage

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @Mike Rini

    I hope you're well and safe!

    Interesting!

    There's the Smartsheet API and also 3rd-party integrations that might work.

    Can you elaborate even more?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Mike Rini
    Options

    Hey @Andrée Starå sure. Basically, the way we have it setup now is in an Excel spreadsheet where we can adjust things manually. The adjustment in the example below would normally be CVR, and in Excel, it'll obviously update the result (Expected Conv) automatically based on the formula without moving off the page. That's the type of functionality I'm looking to emulate. If I can, then I can tie in the other sheets to it, with other variables to make the equation more complex.

    Essentially, I can do this in Excel, but I'm looking for a SmartSheets implementation b/c that's where we have everything.


  • Mike Rini
    Options

    @Andrée Starå just following up and wondering if you had any additional thoughts here. Just looking to come up with a more creative solution than linking a Google Sheet.

  • lcortes
    lcortes ✭✭
    Options

    HI @Mike Rini, did you ever end up finding a solution for this? Looking to do something similar, but all I have so far is linking everything to a google sheet. Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!