-
Automation from a form submission
Hi I have created a form that is working perfectly in that once completed it is populating the sheet data. I have also created a number of automation work flows that work if you directly input into the sheet but do not appear to work if the data is entered via the form - please can anyone advise if I have missed a step or…
-
Question on showing text (comments) from cells in dashboard
Hello Community, I have a form which people fill out and the numerical data from which is analyzed and then put up on charts in a dashboard. However, part of the form is a text box where they can type in comments about the material. Is there a way (possibly through a report?) to have a widget that shows comments people…
-
Can information be pushed into a SmartSheet from an email message
Hi there, I am curious to find out if I can embed a button (or link) into an email that would make an entry into a SmartSheet. Let's say I want to send an email which asks the recipient to choose one of two options. I could send them to a SmartSheet form and have them fill it out, but what I would rather do is have them…
-
How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?
Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the…
-
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…