-
How to restrict Form responses to data existing in the related Sheet
I am trying to create a Form that requires the user to supply information related to any item existing in the Primary Column. If I pull that existing field into my form, the user entry is a free-form field and I can't figure out how to restrict it (other than validating by data types). If I add a new field with a dropdown…
-
Unable to edit smartsheet forms without constant reboot
Is anyone having trouble with smarthsheet over the past several days? Every time I go into a form to edit it, the cursor jumps fields after each character is typed. It is so frustrating. In some cases the cursor gets frozen in a field and jumps back and forth between two fields and freezes the whole system. I have yet to…
-
Form Sharing
I am trying to share a form w/in my academic institution, however, I can add some employees but not others. They all end w/ the @****.edu and are verified email addresses. Has anyone seen this before? How should I proceed?
-
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
-
Form with multi drop down answers - need help to count correct choices
Hi All, I have built a post training test form for a colleague, some of the questions have got multi answer choices (e.g. correct answers can be A, B, C, D or even choice of E - stating that all previous choices are correct; or could be that A,C,D are correct). If correct choice is chosen, needs to return point 1 per each…
-
Submitting forms for approval
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…
-
Utilising multiple forms on one sheet
Hi everyone, I have a project where I need to build a very large form from 2 old ones we currently use. Is there any way to copy each form and run in the same sheet so that my work reduces as I can just then edit, remove and adapt rather than start this large form from scratch? At present I know I can copy one sheet and…
-
Merge multiple forms into a long one
It would be great if we could copy a form or sheet, but do this for more than one to combine. My current issue is creating a new and very large form, but taking parts from 2 old forms, if I could copy these forms into 1 then it would take a huge amount of work away. As it stands, I will have to recreate both forms over a…
-
Multiple Entries of The Same Name Into A Single Row
Good morning, I am newer to Smartsheet so forgive my lack of knowlede. I have created an attendance tracker form to track employee call offs from for our supervisors. Is there a way for example if John Doe calls off 3 days but each day is a separate submission due to different supervisor working, if each of John Doe's call…
-
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…