Formula results in a Smartsheet form

I'm adapting an Excel-based grant application to Smartsheet. It's working well, but there's one feature in Excel that I don't know if the Smartsheet form can do. In the Excel version, we've included fields that automatically total different requested amounts and also show the average amount requested per participant. This is useful to people as they fill out the application, because they can see if they've exceeded any limits to what they are allowed to request.

I already have Smartsheet calculate these things, so I can see them when I work with the sheet. But what I want is for the calculated amounts to show up in the form, so the applicants can see them as they fill out the form. Is there a way to do that?

Thanks,

Jen

Find more posts tagged with

Forms

Formulas

Comments

p_bureau

Hi !

There is currently no way to import data (like formulas) into a form. The form is just manual input, nothing more.

To do such a thing, you need to build your own form with the Smartsheet API and some code. But that requires (a lot of) ressources !

Good luck

Paul.

Jen Pyrzanowski

I need this feature too - I need staff to be able to see if the hours they are entering makes sense across the number of projects they work on. Is there another approach - send them to a dashboard (where I can add a link to the form) and have the hours they are entering per week show up on the dashboard as a total? Would really like a relatively easy solution to this!

Prashant Thankappan

This is not possible in the current state with Smartsheet. Given that I came here looking for the same reason as you are, I think it makes sense to request this feature.

The current form for Feature Requests is here: https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?