-
Form Submission creating new row - cant do notification
I have a sheet which has 10 columns. It is meant to collect data and trigger notifications. The first 4 columns, I have created a form to collect data from user. The 6 other columns are for tracking on status and assigned to user column. The last 6 columns are meant to be fixed (content doesnt change). So when a new form…
-
Using forms to update a record
I've perused the Smartsheet community posts for the answer to this question and get varying results. Objective: Use a Smartsheet Form to update a row (a record) of data. Background: We are currently using an Excel file with a VBScript form to update records of data. The VBScript form allows us to select the record to…
-
Column formula do not appear in form
Hello, Hope you all are good in this crazy time. I'm really new in smartsheet and maybe what I'm trying to do is not viable, so I'll try to explain myself as details as possible: I want to create a form with some fields "auto-fillable" based on a cross-reference VLOOKUP formula. I have a main sheet and there is a column…
-
Does Smartsheet Form have any APIs?
Hi, I'm trying to automate the form submission process for my team, I saw form submission seems to be calling https://forms.smartsheet.com/api/submit, just wondering if we have any APIs open for this like the api.smartsheet.com ones? Thanks
-
Creating a sub-set view of a master sheet for external stakeholders to view and edit
Hello! New to smartsheets, so apologies if this is a novice question. I have a master sheet which I am collaborating with my team on, and I want to be able to share with an external stakeholder an editable version with only select rows (based on a filter) and select columns visible but editable to provide updates. The…
-
Is there a way to download SmartSheet form as a PDF?
I want to be able to use Smartsheet form as a PDF also in cases where I have to manually write information or use the form as a Job Sheet for Complaint/Servicing form. How can I do that? Any help will be greatly appreciated.
-
Submit button on form greyed out
Simple problem - I have a form with only a single required field, which is an attachment, and a few optional fields, however the submit button remains greyed out when the required attachment has been added, and only becomes available when one of the optional fields has something entered into it. I have tried fiddling with…
-
Email as form field and for copy of responses
My organization has just started using Smartsheet and I created my first form. I have a required "Email" field. I also enable the submitter the option to receive a email copy of their submission, which also requires an email. I announced the form and asked for feedback. Immediate and understandable feedback was, "Why do I…
-
Auto adding dropdown options?
Hi, I am trying to establish a training eval form which can pull training titles from an existing sheet as options for a dropdown menu. Any suggestions? @Genevieve P
-
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…
