-
Continuously update a single cell from a regularly updating form?
Hi, I'm new to Smartsheet and was asked by a colleague if this was possible. We're tracking maintenance needs for on-site business assets that will be managed by a large group of employees. I have a sheet with each asset and their subsequent maintenance needs, plus fields for date of most recent update for each. I want to…
-
INDEX, MATCH, and OR Function
Hello, I am trying to use INDEX MATCH and the OR function. I'm referencing 3 other sheets try to say if we find x in any of these 3 sheets I want y from those sheets. x and y will only be present in 1 of the 3 other sheets. However every I do this I either get an error code or unparsable. These are a few of the formulas…
-
Recall/return feature
Hello, I have a question about Smartsheet functionality. My university uses a form submission software for purchasing reconciliation that has a return/recall feature. From what I understand, Smartsheet does not have a comparable native return/recall feature. The closest equivalent Smartsheet offers is the an update…
-
Limit date field in Forms to today's date OR a future date.
-
Amount field in Smartsheet Form should use proper separators
Currently, the number inputted in the Amount field does not have comma separators making it difficult to read the amount when the notification email is received. Smartsheet should look into the idea of adding the separator for clearer definition of the amount.
-
Enhancement Request: TODAY() as default value in forms
Hi team, I find that it would be very useful to the user just to implement a way to set up the date of "today" into data fields of Smartsheet Forms and new entries in Dynamic view. In essence it would take today's date as default value. Upvote if you find this useful so it could be implemented
-
Totals and calculations in forms
allow users to add section to request amounts and total them something like: blue widgets needed - # red widgets needed - # green widgets needed - # Total widgets = # blue+# red+# green
-
Auto Fill changing more that specific section on form
When creating form submissions in the field, one of our technicians reported a bug that may affect others. We use URL string querying to correctly pre‑populate the job address (city, ZIP, and state). However, after scrolling down the form, an Auto Fill popup used to insert the technician’s name and email can be selected,…
-
Merged: today's date an default value option in FORMS - so that you can auto record a date easily
This discussion has been merged.
-
Side-by-side fields in Forms
Similar to other form products (like Form Assembly), I would like to place/format fields within the form with more flexibility. At the most basic level, I'd like to place 2 fields, side by side. My particular uses would be: Dependent Name: Dependent Age: And also: Income Type: Income Amount: I actually could use more than…