-
Merging several form questions into one column
Hi! I have created a form but am having some issues with how fields from the form are collected and reported to employees. The form is a sign-in for sessions. Attendees select their presenter from several lists (e.g. A - C, D - F). These presenter fields are set up as Contact Lists and linked to our users, and each form…
-
Webform options disappear
I have a Smartsheet with a webform and users are noticing that some of the drop-down options for one of the questions disappears. I have had to re-add the option several times in order to bring it back to the webform. Has anyone else had this issue?
-
Date Format in forms
Hi SS Community I use Smartsheet in Australia and use the appropriate date format for my sheets (image 1) with the correct personal regional settings (image2). However, when I use a form from my sheet to input data it shows the US date format (image 3) which has confused some of my users. Is there a setting to ensure date…
-
Hourly view on Gantt View
Hi there, We have a project with vehicles moving across multiple locations and would like to keep tract of their activity by the hour. We don't so much need to track their GPS location as much as, Car # 1 is in Town A, and then needs to go to Town B for 2 hours, then return to Town A. Gantt view would be very effective for…
-
CountIF for a multi-select drop-down
Hello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because it makes the most sense for me. In the sheet summary tab, I want to be able to count how many rows need…
-
Form Entries are Negative
Weekly I have about 15 sites completing the form linked below. The issue, I have roughly two random users each week entering a negative one into the form. One user who is pretty savvy indicated the form is defaulting to a negative one. https://app.smartsheet.com/b/form/ebc99e53148a4a479060b3d695321030 I have NOT setup any…
-
Easy way to copy a nested row into the same sheet
Hello, I'm trying to create a workflow for one of our users to check off when making a new hire, and then when it's done, it'll get moved to an archive. The issue I'm running into is that I can't easily make a template for the users to copy when utilizing the sheet. I want users to be able to stay in this one sheet to…
-
Unsure where WORKDAY fits in with a VLOOOKUP to another sheet
A sheet has task start and end dates for various product tasks. The products and tasks are listed in a separate project task lookup sheet. The Task End Date is calculated as x days from the Task Start Date, depending on what the task and product is. Both columns are Date columns. This formula works, but it doesn't exclude…
-
Moving data from one sheet to another - nothing works! VLOOKUP, INDEX MATCH, INDEX COLLECT
Hi Community! Hoping one of you might know what I'm doing wrong here. I'm trying to bring data from my source sheet (a list of requests) into a target sheet (list of placements). I've created a reference ID that exists in both sheets (KP Placement ID) that is an auto-generated number in the source sheet. It's manually…
-
ADVICE ON A USE-CASE: REQUEST FOR PRICING, QUOTE, APPROVAL, PLACE PO, NOTIFY
We need a sheet or maybe Dashboard / Report / Sheets to accomplish this with our customers. It's a current process we do via email, and want to move it to within Smartsheet. Here are the steps, and am seeking advice on the best process: Via a Shared smartsheet (editor-can share, 3rd party outside of our organization), the…
