-
Consolidating Data from Multiple Sheets
Hello, I'm hoping there's an easy way to do this. I have three sheets, they all are filled in using forms. All three sheets are used for tracking things to be billed to the same list of clients. This client list is identical between all three sheets, if it matters. I'd like a single sheet I can look at each month that will…
-
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