-
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…
-
Is it possible to send a copy of a form to someone else at time of submission?
We have a large field team with a hierarchical organization. Usually the guys at the bottom are submitting forms which are basically project requests. They access these forms through shortcuts on a published dashboard. We have a required contact field in the form for them to select their name and their supervisors' names.…
-
Formula for days of week a ticket was submitted
Hello, I am looking for a formula to put the days of the week a form was submitted. i.e. monday, Tuesday, Wednesday, etc. I already have a created date column which i need to stay as it is but want another column for the specific day that it was.
-
Formulas in Forms
When putting a formula into a hidden line in a form, every time the form is submitted a ' is automatically inputted in front of the formula. This obviously prevents the formula from acting like a formula, but instead just shows the text. This form allows folks to scan a QR code to get the part code (shown as TESTITEM in…
-
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,…
-
Cascading Forms
Cascading Form data sets is one of Smartsheet's missing capabilities that I believe would be a game-changer for many alternative providers. Cascading forms are a very effective technique that can be used to compress form data and limit down options in order to narrow a workflow or collect more accurate data. Recent usage…
-
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…