Hello community, I'm new to Smartsheet and I'm struggling to find out how I can make every value added to my column to become automatically a option in the form dropdown list. Anyone knows how I can do that? Thanks
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,…
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?
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…
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.…
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.
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!!
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…
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…
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…
