-
Dropdown (Multi Select) Sheet Column In A Form
I have a Smartsheet column configured as a Dropdown (Multi Select) column type and do not have the checkbox ticked for "restrict to dropdown values only". While entering data in the column within the sheet itself I am able to enter values in addition to those provided in the field's value list. However, when I attempt to…
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
Counting number of new rows using Created (Date) and resetting each week
Has anyone posted a formula to use that counts the number of new rows added to a sheet based on the system generated create date? I want to do this and have it reset the count each week, perferrably each Monday. I want to: "Look in the Created (Date) column of Sheet 1 and count if the date [that this row was added] is…
-
Pushing data from Smartsheet to 10000ft
Hello, i am trying to set up a project request form which requires authorisation and once this is recieved it pushes fields through to 10000ft as a new project. I can see how to send info through to Slack and MS Teams, but not 10000ft. Can anybody help? Thanks
-
Set a default value in a pick list column
I have a column in a project tracking smartsheet that shows the status of a project. I would like the parent row for the project to automatically change depending on the status of the child rows. I can do that through the formula: =IF((COUNTIF(CHILDREN(), "Withdrawn") + (COUNTIF(CHILDREN(), "Requested"))) =…
-
Relative Default Date in Forms
I'm looking to do a 'Needed by' date in a form and I would like the default to be a relative Today + 2 weekdays. Anyone found a way to nicely do this? ie. Today is 4/29 , the form will default to 5/1 as the suggested Need by date that can be overridden by the user - say they give us 1week instead - 5/6 that should be good.…
-
Logical Condition with forms
Hi, Can we make a logical condition with forms? For example, I have the first selection for Gender and if someone select "male" or "female", it will show different forms for each selection.
-
Update request form after completion/submit not triggering workflow
Hi, I'm quite new to workflow and I'm trying to achieve the following: A document need to be signed by 2 signatories, signatory 1 received an automated update request from workflow 1 which works well. I want workflow 2 to automatically request an update from signatory 2 when signatory 1 has completed his task. I tried…
-
Forms with Workflow
Hi, Is it possible to creare forms with workflow e.g if I click "fruits" I will se options "Apples, Oranges..." If I click "Veg" I will se options "Tomato, Onion..." I would like to create Sales tool for my team so they can go step by step with sales process without missing steps. (Maybe you no other tools for doing that).…
-
Conditional Sections of a form
Hi, Is there any way i can create a form so that, if a certain field is selected from a dropdown menu another field then appears needing to be filled out? Any clarification needed feel free to let me know :) Cheers
