-
Form for lookup and display
I have setup a ticketing system on SmartSheet using forms for submission of the tickets. Can I use the form function to have the user query the sheet? For example, a user submits a Request, and then later, for them to be able go to a form and key in the Request # to look up the result.
-
USING FORMS WITH pARENT /CHILD ASSOCIATIONS IN SPREADSHEET
Greetings, Below is a screenshot of a spreadsheet that has parent / child associations. I would like to create a form that will allow team members to input the various meetings & Times, they have during the week. 1-can smartsheet automatically put the response in child rows when a parent row( week Day) has been selected?…
-
Can a field on a form be conditionally required?
So, I know you can use form logic to conditionally display a field and that if the dependant field is marked as required, it is only required when it is displayed. But is there a way to make a field display as required only under certain conditions? Example: I would like a certain text field to always be available on a…
-
Intake sheets add on process flow task management aligning with project plan
I am setting up a sort of hybrid project with a large cable manufacturer, the project started and stopped during COVID and they had no task management. I am to use SmartSheet for the project plan, which I have mostly in place other than sites not visited yet. At the end of the day, I am standing up an OT network at several…
-
Form Hyperlink in description text not working
Hello all, With the new text formatting abilities in the description box of forms, it appears the hyperlink button does not work. Has anyone noticed this or can help me figure out if I'm using it incorrectly? Thanks in advance, Rachelle
-
Printing Reports
I want to print out reports from the smartsheet and print out like it is shown from when you get an email copy of submitted forms (if that makes sense). Currently I am only able to select an entire row and it prints it out very small and stretched to 2 pages. Can I have it wrap the text/columns? I need it easily visible…
-
Rows Not Appearing
I'm trying to troubleshoot a sheet I have. I have several entries that are not appearing on my sheet, and any new entries made are also not visible. I have a report generated off of the sheet and it reflects all of the entries. The approval, update, and assignment automation is also working just fine. They are given a row…
-
Control on form to not have duplicate contact
Not sure if this has been asked here before, apologies if I have missed it. Is there a control that can be added into the form that will not allow two fields to have the same data. For example 8f there's a requester and approver contact field, can I add a control that would not allow you to populate the same email address…
-
Copying a Sheet & Using Formulas Changed the Form Attached to Original Sheet
Hi SmartSheet Community, I came across an issue with copying a sheet and the form that was attached to the original sheet was modified from using a formula in the copied sheet. Original Sheet Name: IHA Copied Sheet Name: Copy of IHA INDEX/MATCH Sheet Name: Job Model After I copied the IHA sheet (File --> Save as New), I…
-
Pull Data in from a Master Sheet Using a Unique Group ID in a Form
Hi, I am hoping that someone can help me. I am trying to update a Master sheet of data using forms. The Master sheet is partially-populated and each line of data has some empty cells. The Master sheet has over 200 line items, but the individual lines are grouped by unique group IDs. Specifically, I am trying to create the…
