-
Dropdown and Pick Lists
Hello, Is it possible to populate a dropdown list with the column of a seperate sheet. Scenario. We have a Sheet containing all our Assets and one for all our Work Orders. When creating a work order (new row) in the work order sheet, or via a webform, we would like to pick the relevant asset the work is linked to. If we…
-
Setting character limits on SS Cells or form area
Does Smartsheet allow you to set a restriction on the amount of characters allowed within a cell or in the txt box within forms? Thank you
-
Help with Auto Number/System - Created By field
I inserted a column where the type is Auto Number/System - Created By, but I am running into two problems. 1. The field auto-populates with email address. Is it possible to auto-populate with user name instead? 2. When adding the new row through a web form, the field populates with "web-form@smartsheet.com." Is there a way…
-
Attaching Forms to a Row
I am needing to keep a copy of the form after my employees submit them. Is there a way that the form can be attached to the row once it has been submitted? What about being able to print a copy of the form once it is submitted?
-
Location of Web form submissions in SmartSheet
We have generated a SmartSheet webform to link with an existing work resource tracker. We have found that the webform entries occur far below the existing list (e.g., ~ 200 rows below). Is there a way to adjust where the webform entries occur once submitted (e.g., below the last row in the sheet)?
-
Blocking already selected dates in Smartsheet Forms
Hi All, I have a smartsheet form setup to allow users to book events. I have added a calendar option in there to allow them to choose the date. I would like to block/grey-out the dates which have already been chosen. Currently I see no option when editing the Form which would let me do that. Is there a native way to…
-
Multi-Row Approvals
I want to migrate an existing SharePoint InfoPath form to SmartSheet. The form is a Budget Request Form. * Staff can submit a budget request with arbitrary number of items (rows) * Via a workflow, each item is Approved or Denied. * Via a workflow, the entire Request is Approved, Partially Approved, or Denied. The thing…
-
Best Practice - Data Integrity - Forms
When your business starts to build lots of sheets (as we have) the issue of data integrity comes into play. That is if you have lots sheets with names, or activities you can now put them into one sheet and reference to them BUT whenever you build a form and want to restrict the user selection to the defaults in the drop…
-
Multi Contact List not populating from Form
I am experiencing an issue where a contact column with values added is not populating to a sheet from the form when 'allow multiple contacts' is selected. Is anyone else having this issue? I have also submitted a help ticket.
-
Reference an infinite range starting from row x
Is there a way that would enable me to reference an infinite range starting from, for example, the 5th row down. Currently, my solution is to use indents and use the CHILDREN([Columnx]x) function. HOWEVER, unfortunately it seems like this is not a solution compatible with webforms. Is there a way that I can do this, that…
