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
Sign in to see the current vote count, add your own vote, or leave a comment.
I agree. Even though a record is not actually created until the form is submitted, if the column has a column formula or uses any sheet summary fields, they should still be operational as a form is always attached (subordinate) to a sheet.
This may be difficult to achieve if the formula uses @cell (not sure). But if there is any restriction, then didn’t allow such columns to be ‘pre’ calculated or selectable in the form.
Along these lines, any conditional formatting from the sheet (for input or calculated columns) could also be allowed to flow through to the pre-submitted fiom.
It would be great if you were able to use a column formula column in a form. For example, I have an IF statement that defaults a cell value to "N/A" if a condition is met in the previous column. That column is used in document mapping to show the end viewer of the PDF that the cell was not applicable.
I'm creating a system for tracking CAD requests in an R&D department. One of the features of the system is that it tracks the average duration by task type dynamically. As each task is marked complete, the calculations happen automatically.
I'm using a form for request intake. It would be nice to have the form show the average duration for a specific task once the user selects the type of task they are requesting. The form also has a field for the date required. I'm instructing users to consider the average duration when the select this date so that it is realistic. At present, I have the metrics displayed on the dashboard with a big note next to the widget that takes them to the submission form.
If they forget the number or don't bother to look, they will have to go back to the dashboard and then return to the form to be able to fill it out properly.
Assuming a sheet has a column “available slots remaining” that calculates a beginning number minus total slots submitted by forms. If a form could show the calculated value of “available slots remaining” from the sheet. For instance if there is going to be a class with 20 slots, it would be helpful if the form showed “15 available as of..” then provide a time stamp of the last time the sheet was updated. (Or w/o the time stamp, I’m just trying to address the issue if multiple people happen to open the form at the same time. To add to this, as mentioned on other comments on this idea, if it can could take the # of slots the submitter wants times a cost per slot could be calculated on the form to be seen prior to submitting.
It would be very helpful and a popular function if fields with formulas could be displayed on a form. This is very helpful for situations where multi-step decisions on a form are required.
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
I had Technical Support Case #09045069 in relation to this issue. I was told to get the API documents corrected, I needed to post to here. Update API Documentation Some (all?) of the API calls related to Alternate Email Addresses require both an Enterprise Account and to be manually activated by Smartsheet Support. The API…
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
