-
Can approvers of Smartsheet forms be added without giving access to the sheet?
I am creating a form in Smarthsheet that will require two levels of approval is a particular question is answered in a certain way. In the form they manually enter the email address of the people who are required for approval. I am finding that if I do not share the sheet with the person I am seeking approval from I cannot…
-
Forms
OUr forms are randomly requesting participants to complete a CAPTCHA request, however, we have not added this to our account and if it is going to show we want it to happen with every form submitted and not just random few. How do we correct this?
-
How to create report with rows instead of columns?
Why does Smartsheet only allow you to make a report with columns and not rows? I'm using my sheet to coordinate data for events. Each row has a specific event, each column has different details for the events (date, location, hotel, meals, etc) and I need to take information from only certain rows to create a report for…
-
Send Update - To update only selected cell?
Is there any way to allow only selected cell for updates? Reason being that I would not want other data in the row to be accidently and wrongly updated. Thanks!
-
Sight form links update when making a folder copy
Hi, May be i am missing something, how can i attach forms to a sight so that when i make a copy of the complete folder (with sights, sheets and reports) the form link is updated as well, just like sheets are. Greetings Gijs
-
Web form submitted child rows - how to sort them into place?
Good afternoon, I have a sheet where we are tracking time allocated to various projects. Each web-form submitted project is then given a parent/child relationship with the child row being the submitted info and the parent being the summary view of all the children by the same project name. However, when I try to sort new…
-
Identifing rows based on multiple form sources
We have a form which is sent to customers to register their commercial contact details. The customer doesn't always know which product they are receiving so this is added to a sheet column after population. However, a new row triggers notifications to various internal stakeholders and they receive this notification before…
-
Create a SubSection of a form
Hello, I am working on a form and was wondering if there is a way to not have a label for one of the sections. Currently I am using the Section dividers to group the main questions so I don't want to use these again since the formatting would be confusing. but I have one question that has 2 smaller parts. So I want to have…
-
Using formulas to copy, or transfer data between cells.
Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…
-
One column is not populating from my form
I have a pretty straightforward form set up but one field (one column) is not populating into my sheet for some reason. It's a contact field with dropdown options. It shows the dropdown and lets me select values, but when I submit, they don't show up in the sheet, although all the other columns do. I've tried deleting and…