-
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…
-
Using Smartsheet Forms as multi lingual survey tool
Hi, I am using the forms function to collect data from people in many different countries. The information we are collecting is in binary, single select, and multi select formats. This information is being summarized in a separate sheet, where we are counting the instances of each response from the binary, single, and…
-
Can I populate multiple lines in a report from one form
I am trying to automate our joint health and safety checklist. I have created my data sheet with 88 columns and created my form. Each question has a drop down with yes, no or N/A. When no is selected a comment box comes up to insert the issue. What I want to do in my report is create one row for each issue that arises…
