Forms
Discussion List
-
Can a form update a specific row, rather than just adding rows to the bottom of a smartsheet?In Using SmartsheetI have a form and I'd like the form to recognise an already existing row on its linked smartsheet where the submitted form contents update a given row. I think it might be the case that forms just add rows to the bottom of a smartsheet (an…
-
Strange Formula BehaviorIn Formulas and FunctionsGreetings, I am developing a solution that automatically captures a 24-hour time (as an integer value) from the generated system date/time. The goal is to allow users to use a form on a tablet to enter a few fields of information…Answered - Pending Review 35 views 5 comments 0 points Most recent by Sameer Karkhanis Formulas and Functions
-
How to use index/match on multiselect dropdown list?In Formulas and FunctionsI am working on launching a global hiring form that uses this formula: =IFERROR(IF([email protected] = INDEX({Approved Seats Country}, MATCH([Unique Seat Code]@row, {Approved Seats Unique Seat Code}, 0)), 0, 1), 2) Basically this formula returns…Answered - Pending Review 42 views 1 comment 0 points Most recent by Leibel Shuchat Formulas and Functions
-
Mapping out the logic on a formIn Using SmartsheetI have a form that uses logic in some of the fields and I need to map it all out for others to review and make sure I'm not missing anything. The form is fairly long. Is there a template for a workflow of some sort that might work? I need …
-
Barcodes scanned into a webform not converting to a number automatically in the sheet!?In Formulas and FunctionsHoping someone can help with this promptly as I haven't got an answer from my support ticket from the 19th. We have a grocery store and the floor team scan the barcode of the stock coming into the store into a form and select the qty and e…Answered - Pending Review 33 views 5 comments 0 points Most recent by Jeff Reisman Formulas and Functions
-
Help: formula won’t apply to a new templateIn Formulas and Functionshello, when a new templete is submitted, my formula won’t apply to the new row. Other columns will apply the formula, however “End Time Parse Left” won’t. How can this be resolved? please see photo below:
-
Formatting not staying the same for new form fillsIn Formulas and FunctionsI noticed that in my sheets the $ currency column formatting or the align formatting do not stay the same as the rest of the column for new form fills. For example, before if I inputted in 100 in the $ section it would go to the sheet as $…
-
Way to have multiple people claim an itemIn Formulas and FunctionsHello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column. I am looking for a way to have m…Answered - Pending Review 32 views 1 comment 0 points Most recent by Kevin Smith Formulas and Functions
-
Document Builder Automation with FormsIn Using SmartsheetCan Document Builder be automated so that after a form is filled out the document is automatically created and sent to the person who filled out the form (or any other identified person)?
-
RoundingIn Using Smartsheet@Genevieve P. I hope you are well sorry to as again, please could i have some assistance on the below question. I want to type in 5979.100258 in a cell, for example, and it's rounding up to 5979.10026 - which I don't want. How can I get…