-
can forms have totals?
I want to add to a form a section that asks people for amounts and then totals it, is that possible? something like: blue widgets needed - # red widgets needed - # green widgets needed - # Total widgets = # blue+# red+# green
-
Input form for multiple sheets
I originally had an Excel worksheet with multiple tabs. The first tab was an input sheet which fed into 100's of formulas in the other tabs. The other tabs (one for each country) used the values from the input sheet to do the numerous calculations. In Smartsheet, I imported each tab (input sheet and each country). I also…
-
Smartsheet Form - Latest entry is the only "actively" reported
Hi, I have a form for people to fill in that reports how ready they are for security. As this is evolving they can be expected to fill this in from time to time to measure how ready they are. So I only want the latest line from the form to be reported on. My system in place for this at the moment is to have a "Constant"…
-
Form default to today's date
I want a form to default to today's date (date submitted). A previous post (2017) showed how to do this by selecting the 'Today' button on the bottom of the calendar in the field settings of the form. However my calendar does not have a today button.
-
Error when submitting a form
Any idea why this error or what to do about it? I have admin access so it's not an access issue...
-
Fillable PDF
Has anyone tried to use the submit button on a fillable PDF form to send data into smartsheet? Doens't seem to difficult but could use some guidance.
-
Can one form link to two sheets?
Hi, I created one form but can the data be linked to two different sheets? Thanks.
-
Does Smartsheet forms have the equivalent functionality as MS Forms to jump to end of form?
Hello, I'm using conditional formatting on a Smartsheet form to vary the subsequent questions. However, there doesn't seem to be the same functionality as MS Forms, which allows you to use branching (aka conditional logic) to jump to the end of the form. I'm wondering how this can be achieved, if at all?
-
Filter on card view when using forms
I'm setting up a form for people to submit requests to my team - it's a large form with a lot of logic input into it and there are 20 different categories that people can choose from when submitting a request. I want my team to be able to easily see the jobs that come through as in grid view it shows all columns (even…
-
How do I pull in a table into a Dashboard?
I linked a form to a sheet that has the data that I want to pull into a dashboard. How do I create a table from that data into a Dashboard and be able to format it as needed.