-
Adding an additional requirement to a formula
We have been using this formula to add up the hours spent working specific clients -- been working fine. We have also been asking what category of work they have been completing at these clients but haven't been utilizing the data. =SUMIF({Kinsman - Job#1}, [Scope of Work]@row, {Kinsman - Hours#1}) I now need to add an…
-
Capture Email address on form submission
Hi Is there a way to automatically capture someones email address when they submit a form entry? I'm looking for a secure way of capturing who the user is without asking them to select their name from a drop down list (within the form). I've tried embedding the form link into an email, hoping that would feed through into…
-
Smartsheet + Jira workflow - attachments and multi-select
We are using a smartsheet to populate a jira project. basically, a user fills out the webform, it updates the sheet, and then we push that into jira. The first issue I'm having is attachments. Is there a way to attach the attachment to the new jira story created from the line item in the smartsheet? it doesn't appear as an…
-
Form where a signature can be added
Hi, my boss would like to create a form that would be sent to an employee when they make an error. The employee would review the document and then need to sign it. Like a Doc Sign document/form. Is that possible or does anyone have a work around suggestion. Thank you Raelyn
-
Checklist Form to Upload docs to DropBox
I have a form to collect data from Property Managers for each of my tenants. Each column is a document with a yes/no that will be checked on the form if the Property Manager uploads the document. Also on the form is a URL to the Dropbox folder where the documents are to be stored. When I trial the form it sends me to the…
-
Auto-populating form fields
I'm working on a form right now and am having some issues that I'm hoping someone can help me with. I'm trying to develop a form that auto-populates specific fields. Something similar to the "request an update" feature, but in a form that I can edit the look and layout of. I've tried using a query string, but so far I…
-
Cell is considered "changed" when it goes from Blank to Filled - Why
I have a sheet set up that populates rows with information filled out from a Smartsheet form. Rows are only added by filling out the form. When a row is added (i.e. form is submitted) a notification is sent out to a mailing list of individuals. This all works fine. I have a separate workflow notification in the same sheet…
-
Recording the date of a specific update and locking that date?
Greetings SMARTsheeters... Not sure if what I'd like to do is possible in SMARTsheet, but here goes... I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupdate email requests. There will be various users entering and modifying the data in the SMARTsheet adhoc through these forms…
-
SMART FORMS TEMPLATES
Is it possible to create a smart form as a template that you then move between sheets. I have a sheet for each client but want to use the same forms for each one with out having to recreate every time. Thank You in advance a
-
URL for a Web Form
I have to publish the Web form link on SharePoint for internal staff to access, fill & submit their requests. If there are any changes in Web Form in future will original URL work? or it will change after changes done in the web form?