Smartsheet live calculating tool (dashboard or form)
For work, when we hire people there are variable and fixed benefit rates based on the type of employee they are. I would like to develop a tool much like a smart form where the user inputs hours per week, wage rate, start and end date and type of employee, and the form displays the total cost of hiring that person. I have grid sheets that do the background calculations. the only option I have is they submit a request a
Answers
-
Hi Jeremy,
Are we missing a part of the question? It sounds like you have the start of the correct set-up: if the different employees submit the form you can build formulas to create the calculations you want. Then you can use those calculations to display in a dashboard or report depending on your set up.
If you need help building the formulas for your calculations, it would be helpful to see a screen capture of your sheet in grid view (but please block out any sensitive data!)
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 61.4K Get Help
- 325 Global Discussions
- 184 Industry Talk
- 418 Announcements
- 4.2K Ideas & Feature Requests
- 127 Brandfolder
- 154 Just for fun
- 124 Community Job Board
- 441 Show & Tell
- 26 Member Spotlight
- 1 SmartStories
- 278 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!