Smartsheet live calculating tool (dashboard or form)

Options

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

  • Genevieve P.
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!