-
Logic in Forms
I am looking for a solution to use logic in a form for the following: Column: Chose a Fruit? Drop Down Apples, Oranges, etc. Then from logic, I would like to have it access a column that has different types of Apples. Such as Honeycrisp, Gala, etc. Is it possible to have logic access different columns with additional…
-
Am I doing it wrong? Salesforce connector, Mesh, control center, Data shuttle ugh and now RM
:) Replacing a JIRA system that was not really used well with Smart sheet and Sales force in a united front to try and perform work flow, report out, and track time, then export for billing back to Salesforce. High level, we have a pre sales sheet that captures input from Salesforce on win, loss, and or type of project.…
-
MS Power Automate Get Last Row of Data
The desired flow is: Smartsheet form is completed which includes three key pieces of info: Name, Email, Waiver This creates a new row in a Smartsheet A Power Automate flow is triggered where it checks specifically the Waiver (which is a dropdown either needed or not needed). If needed, the flow continues. I built an…
-
Using DataMesh to Split One Line Onto Multiple Lines (for Forms Entries and Other Uses)
This is a problem I've heard a few times so I'm answering it in a separate post for reference in long form. I'm using the example from @WtaylorW's question over here. The basic need is to take one line and split it onto multiple lines. In this example you have a form that's inputting multiple names in different columns,…
-
Add pages to Intake
How can I add pages to an intake form? I created an intake form that contains over 50 questions ad I would like to split them up into 5 pages of 10 questions but I'm unsure how to add pages within the Smartsheet form. Any help would be appreciated
-
Replacing form entries instead of copying
I have a smartsheet with a form automation that collects information like a survey. However I want to make it so when an entry with detail such as name is already in the smartsheet it replaces it with the new form data rather than creating a new entry.
-
Form Logic based on multiple column selections
I've had few interactions with Smartsheet users in the Unanswered Questions that have prompted a form upgrade idea that I believe would be useful for many. It would be nice to have the option for logic on a form to trigger a response based upon multiple column selections. I have had multiple questions asked on Unanswered…
-
Outo populate a field on a form when the form is being fill out
hi, is there a way that in a form i can have a way to outo populate a section (let say name ) when the fill out their information. Specially if I already have an IF function that does it in the background? For example: if the person adds a specific number it will show am specific name, pulling it from the the IF cell in…
-
Copy of Submission Not Showing All Columns
Does Smartsheet show all columns in the "send me a copy of my response" email from submitting a form? We used to show a critical piece of data in that our submitters would use for their records but now that column no longer appears in that email. The column used to display in the email, and has not been adjusted since the…
-
How do I make a form field's visibility dependent on 2 fields?
Hi, I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following: if [CheckboxA] show field 1 if [CheckboxB] show field 2 if [CheckboxA and CheckboxB] show field 3 There is no way to do this within SmartSheet forms. You have to have a helper column in the…