-
Indirect drop downs in Smartsheet form/ dynamic view
Would like to get my form structure that allow for indirect drop down, i.e. I have several countries (Kenya, India etc) with each country having a list of industry processors - and each processor having their own product brands (probably 3-4 product brands). Would like a form that based on the country selected (field 1),…
-
Issue when selecting multiple sheets in a report
Hi, I noticed when selecting multiple sheets in a report that I am unable to unselect them. Before, I was able to select the main folder or sub folder, and that would allow the source sheets to clear out. Now when I go to change it, nothing shows selected (see screenshot). This is a super pain because now I have to…
-
Copying/Moving rows
Hello I am hoping someone may be able to help me. In this example I have two sheets (sheet A and B). On sheet B I have parent rows with child actions which vary depending on which team is using the document. If someone inputs data into sheet A under a particular team, is there a way to set up an automation to copy the…
-
Form has a contact list field, for the contacts are not pulling into the form
Hi, We created a form to take in change request. The sheet has a column 'Interested Party" and this is a contact list. When i am in the sheet, i can start typing a name and the contact list based onthe spell comes up. This does not work the same in the form. Is there a setting that I am missing?
-
Form link field validation
Hello, Is there a way to add validation to a hyperlink field on a FORM? I could run a check after submittal, but that is more effort than it is worth. Double Dipping here: I was reading an article on the best online forms. They recommended the error notification be immediate. I have many students baffled by what is wrong…
-
Approval Workflow: Record Name of Person Who Approved
When a approval request goes to multiple people, is there a way to record into a column the person who did the approval (e.g. Approved By column). I can see out who did the approval by reviewing the 'View Cell History' on the column that has the approval status; however, I would like to put the Approver name into a field…
-
Merging several sheets
Hello, I have 8 sheets from different companies that fill in information periodically, and all the columns have the same name. How do I create another sheet that combines all of this information? thanks
-
Paginate a long form
Hello community, I'm new to Smartsheet and have a few questions for using the Forms. I have a survey questionnaire with 20 questions. Is there a pagination feature in Smartsheet that lets me break the long form into several pages? It's a common feature in mainstream survey tools like Qualtrics or SurveyMonkey. Is there a…
-
Update Request Automation not sending to free users despite "Unrestricted" Automation permissions?
I have an automated "Update Request" workflow set up on a sheet to send to contacts in a cell, and I'm getting a an error message saying that this email is not being notified, and that I need to change the Automation permissions to a less restrictive setting. The email address is for under our work domain, so that…
-
Error attempting to create a Sheet Summary Report
When I attempt to create a sheet summary report on a sheet that I am the owner of, I always get an error. This happens on any sheet, not just this one. I did create 3 different summary fields. Any ideas: