-
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…
-
Why does Smartsheet add a single quote before an integer that begins with 0?
A single quote keeps getting added when a 0 precedes an integer regardless of the entry method for the cell’s value (e.g., when the values are imported into Smartsheet from an Excel file, when the values are copied and pasted into Smartsheet or when the values are manually entered). Example: 099999999 changes to ‘99999999…
-
Equivalent to Asana Collaborator Notifications?
Hi all - we're in the process of trying to move from Asana to Smartsheet. In Asana, you can set "collaborators" on tasks and they will get notified of changes, even if they are not directly tagged in as the person its assigned to, or @'d in a comment. Is there any way we can replicate that in Smartsheet? I would love to be…
-
Nesting IF, AND, and OR
Hello there! I am working on a project that will allow us to do a very quick visual check when a date is inside a work window. The problem occurs when a work window has two date ranges, this example being 07/16 to 07/30, and then another work window between 11/15 and 02/01. Not all work windows have two work windows, but…