-
Using a form to submit hours for projects
I would like to set up a simple sheet where PM can list several projects and anticipated # of hours to complete each project. I would then like a form or some type of automation that allows employees who are working on a project to submit the # of hours they have worked on it. Is this possible to do with a form and if so,…
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
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…
-
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…
-
Merged: Ability to add character limits to Text/Number column type
This discussion has been merged.