-
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!!
-
Current User Filter
Hi I have a report that is filtered by current user. The sheet contains requests people submit via a form. I have set the form that allows submissions without the user being logged into smartsheet and this appears to be now giving them a number (see screenshot of filter below) This is now causing my report filtered on…
-
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…
-
Drag and Drop Outlook Emails (*.msg) Files into Smartsheet Forms
Is there a way to drag and drop .msg files directly into Smartsheet forms? So far, I'm only able to save an email to my desktop (automatically saves as a .msg file), then click and drag it into the Chrome internet program where it uploads perfectly into the form. The form obviously supports outlook's default message…
-
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…
-
Merged: Ability to add character limits to Text/Number column type
This discussion has been merged.
-
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…
