-
Form not auto populating fields if one column cell contains a comma
I'm using a form that when triggered, populates several fields from a source sheet then posts to a another sheet. I've noticed that if the column titled "Description" has a comma in the text of a cell, such as image 1 below, then the form will not auto populate all of the fields that I want. It will also stop populating…
-
Auto-populate form responses from another sheet
Good morning! I currently have an intake form for basic requests for one of my departments. I also have a separate intake form for larger projects that need project management involved. What my ideal situation would be is that when the status on the Basic sheet changes to something like "Needs PM", it would have an…
-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Rich text format on Form input
I would like to have an option to format/edit text (such as bullets, bold, italics, hyperlinks) when typing into a smartsheet form? All inputs collected on this form goes directly on Dashboard, and we have so many format inside.
-
How do I connect SmartSheets Form to send an approval or reject notification to the project manager?
I created a Form for my spreadsheet that allows user to request a change to a specific date in the project plan. The form needs to go to a project manager for approval or denial. If approved → that cell date should automatically update based on the response. Is that possible? Should we skip the form and allow user to…
-
How do I automate the creation of a project schedule from a form submission?
Hoping someone might be able to help me figure out this workflow: Form is submitted requesting a new project with the following information: name of project, requested go live date, assigned project manager This form submission triggers a workflow that will automatically pull a project template, inserts "name of project"…
-
Merged: Dynamic Contact lists - User groups to populate dropdown and/or forms to reference user lib…
This discussion has been merged.
-
Tracking Missing Submissions
Hi! Thank you for considering this problem, I am very new to Smartsheet. I have a form that I have 10 regions complete monthly. There is a due date for each month. I would like to generate a report of those of the 10 regions that did not submit a report monthly. How would I go about doing this? Thank you again!
-
moving Just a Column to a new sheet with Automation
is there a Way that i can Move just a Column in a Sheet to another Sheet that will just Grab the Column. i would like it to work like the Automation that it Grabs the Row any time something is Triggered. but i would like it to just Move the 1 Cell from a Column not the Row as i don't need anything else just what got…
-
Form Ranking
Need a way to poll participants and have them be able to select their top five topics in order of most importance. For instance, if you have 10 potential topics of interest and you would like your participants to indicate what their top 5 priority topics are. From this information, we want to know what are the topics of…