-
Request an update on specific fields based in a form with logic
Hello! I hope someone can help or provide any insight. We have implemented a sheet to review tickets using a smartsheet form. The tickets are categorized in 2 (lets say "Category A" and "Category B"), so each category has different options to review and the form has a logic depending on the category are the options…
-
Merged: Formulas in Forms
This discussion has been merged.
-
AVG error message (with formula issues as well)
I'm trying to calculate the average score (1 to 5) of a column, but keep getting the DIVIDE BY ZERO message. The column with the scores is calculated via a formula from a column formatted with stars (from a survey form). So four stars from the survey = 4. But I noticed that all the results have a ' in front of them (e.g.…
-
Bullet Point Formatting Matching Text Color
If possible, it would be helpful if the color of the bullet points matched the text next to them instead of only being black. If I have a dark color background, I cannot see the bullet and if I use a circle, •, instead the indent formatting is problematic.
-
Forms
Hello! I'm working with forms. I have created the form and made it active. When testing I'm not seeing where the submissions are going? IT shows 2 submissions. How do I get to the submitted forms? How can I connect the form so when its completed submitted the data auto populates into the sheet? Thank you!!
-
Unexpected Error Message
Hello - my sheet has a form that sends an automated email with a link to users populated in a dropdown via a checkbox. I've got a user who is receiving an "unable to determine your identity" error message when she clicks the link from the Smartsheet automated email. Does anyone know how to fix this to get my user access to…
-
Remove "work" and company title/#employees from free account registration form
The form/survey function is great, especially when adding a login. However, we cannot use a survey for individual use. For example, we want customers to share information with us via a form survey. They are individuals not affiliated with a company. To register, Smartsheet wants a "work email" then asks for their title and…
-
PICK CHART to determine Project viability
Hello, We are starting to use Pick charts to determine project feasibility and impact so that we only work on the most important things. It would be really great if a template set was set up with a project plan template like Template Set - Project Management Office where the template set would have a project submission…
-
Can I establish a form workflow that builds on each other for the same request?
Hi all, I'm looking to establish a 3-part workflow that will have 3 forms that will build off the initial request. Here's my scenario/steps: Step #1: User A submits an intake form. Step #2: Once that intake form is submitted, it triggers an alert/workflow to Owner A (owner of this process) to complete another form that…
-
Retrieve the form URL via an API call when the sheet is created
Hello Smartsheet Community, I hope you're all doing well! Im relatively new to smartsheets and I'm currently working on an automation process using the API's within Smartsheet where new sheets are created from a template. This template has an attached form that is crucial for our workflow. Currently, we can retrieve the…