-
Countif lookup by email/contact
Hello - I have a sheet ("Sheet 1") where users enter various entries/plans, etc. via a form and to associate it with themselves, I have them use their email address which logs into a contact column. In another sheet ("Sheet 2")- I have a list of everyone who is expected to put in information. I have a contact column with…
-
Auto-Number creating duplicates!
I am using an Auto-Number column in my sheet to generate a new Request ID with every entry. I noticed this morning that there are duplicates of the same Request ID in the sheet. This is a concern because the RQID needs to be unique for each record. There are two ways a record is created with the sheet. One is if a user…
-
Delayed automatic form entry response
We wanted to create automatic delayed response to a form entry. It would send email back to whatever email was entered into form field 72 hours after the form has been filled. The response would say something like: "Your request has been approved". We wanted auto data stamp column to generate that response but automation…
-
Drop down menu in forms don't show the Symbols
How do you get the drop down menu in web forms to show the symbols instead of text?
-
Multiselect Field Option Disables Field as Lane in Card View
I've noticed that in converting fields to the new multi-select format, that this field becomes no longer available as a lane in Card/Kanban view. Was there a reason for this? Will that be resolved soon?
-
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
