Dynamically update form data

Looking for help...

I'd like to update the fields on a form dynamically.

Example: Use the system-generated Creation Date to calculate a "Delivery Date" 2 weeks in the future and display it on the form. I know I can do this on the Smartsheet but I don't know how to display it while the user is entering information.

Find more posts tagged with

Forms

Construction

Formulas

IT & Operations

Comments

Mike Wilday

This currently isn't possible with Smartsheet Forms. But you could probably set up something that emails them the Date based on when a new row is entered? And include that date in the email? Perhaps a notification based on a new row being entered would work?

https://www.smartsheet.com/blog/new-in-smartsheet-advanced-notifications

john.spikula42751

Thanks, Mike. It's a bit awkward but might work. I'll play with that and see what happens.

Mike Wilday

Yes, but with notifications, you can adjust all of the text from the email and they would never know what triggered it!

Arvind Manoharan

Is there a solution for this?

I'm also creating a form that needs to calculate expenses incurred by user for specific travel categories. However, I want that total amount shown on the form and should dynamically calculate based on user input. This would help the user filling out the form to ensure the amount entered per line is accurate prior to submission.

Any way we can achieve this functionality? I can see it happening with a calc field on the sheets-level but that's only after a record is saved. The form functionality request is during the time the form is filled out. Thoughts?

Sign in to join the conversation!

Quick Links

Trending discussions

Set contents of two columns into 1
Hi - trying to figure out a formula that combines two columns into one long column, maintaining contents in multiple rows. Noting that the number of items in each column will change as these are each using the index/distinct to summarize a separate sheet. For example: Thanks for any help!
Unparsable formula; Sheet summary SUMIF formula
Can anyone help why this formula is coming up as unparseable? I'm creating a sheet summary, where it totals the Estimated GP (Est. GP) column if the Status column has the "Quoted" drop-down option is selected. Formula i've used: =SUMIF(Status:Status,"Quoted",Est. GP:Est. GP) Thanks a lot!
INDEX/MATCH Most Recent Entry
I am trying to pull from a sheet that is essentially a list of new records that are entered weekly. To keep things clean I have a helper sheet that just lists the project name once and the rest of the columns pull in through an INDEX/MATCH. I am trying to have that helper sheet pull in only the most recent entry. There is…