Creating a Calculator
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
-
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.
-
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.
-
@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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!