-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
-
Bug with checkbox fields
I created a copy of a sheet that contained checkbox columns (restricted to checkbox only) and deleted the existing data. This then made the checkbox fields inoperable as it didn't accept the checkbox (even on new rows).
-
Updating rows without re-running filters
Hi. I'm an active user and have a filter that hides "done" rows. As I'm working, I frequently marking stuff as done, but it rarely if ever hides the rows with that new information. In order to make the rows actually hide, I need to turn off the filter (which causes a page reload), and then turn it back on again (yet…
-
Filtered Views for External Collaborators
Hello, i am not sure what the best way is to accomplish this. I have a smartsheet that i would like to collaborate with outside vendors. I would like to avoid chopping up the data and giving every vendor their own sheet. I will be adding new data weekly. Update request won't work because they could be getting 20+ lines at…
-
No restrict to dropdown values on form
On the sheet, if I dont check on "Restrict to dropdown values only", then I can type a new value into the dropdown column. But on the form, I cannot type a new value, even I choose not to check "Restrict to dropdown values only" on the column properties. Is there any way that I can create a dropdown field on form and still…
-
How to automate putting rows (based on conditions) of one sheet to a second sheet?
Hi, My sheet 1 has a structure with column 1, 2, and 3. My sheet 2 has a structure with the same columns as sheet 1 - column 1, 2, and 3 - plus new columns column 4 and 5. Based on values in column 2 in sheet 1, I would like to export the row in sheet 1 that satisfies a condition, to sheet 2. Once sheet 2 is updated, I…
-
New Graph functionality
Hi, We have been pining after graph functionality for a while in smartsheet and thought the latest release may have addressed this. Could anyone suggest a way to address the following (please see attached picture) We would like to add a target line to a bar graph to visually see where employees are over allocated.…
-
Dashboard and Sheet Not Updating Cell Referencing
I have a sheet with multiple countif formula referencing data from multiple sheets. From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions based on it. However, when I log back into my for some reason I see the totals in the dashboard reflect old data, and when I go…
-
Multiple sheets consolidate in a hierarchical single sheet
We have sales team members having their own sheets to capture their client info and industry-specific potential billings. Please see attachments exec1 and exec2 Is there a way for the Sales Manager to view all of this in a single sheet that is grouped by industries? The fixed objects are Industries. The variables are the…
-
VLOOKUP Calculation Lag
Hi, I am having problem with a VLOOKUP process. Our current process flow is as follows Import data into a "DataDump" sheet through API, at this point each row of data is assigned a number, matching that of the row number (we do this so we can use an index match formula to pull data through to the secondary sheet we call…
