-
SUM between Sheet 1 & 2 for Time range
Hi everyone, I'm stuck and need a little help. I'm trying to group Time ranges either both columns "A & B" if doable, or just column "A" into multiple 3-Hours bucket for the day with =FLOOR or similar and pick the highest number of Customers from same bucket/ time window of 3-hours with =LARGE from Sheet 1 & Sheet 2 then…
-
Card View - Selecting View By Lanes
I want to select a certain column from my sheet to be the "view by" lanes. I only have a choice of a handful of columns, none of which are very useful to me. The column I want is available to add to each card via "fields" but not in the "View by" selection. The columns I want either contains an equation/calculation and or…
-
Combining Data from Multiple Sheets in a Sight
My team and I are having a problem with the combination of data from multiple sheets showing up in our sight. Originally, we had a couple sheets that all had formulas returning data at the top of each sheet. I then cell linked the cells from these sheets to allow one sheet to add them all together. This then allowed just…
-
Adding information to templates
I am trying to work out the best way to do this. I have an evolving list of products (hundreds and hundreds) that can be ordered, and 29 people (only - this is set) who can order them for a Bulk Buy once a year. My current plan, was to create a Template, then have a sheet for each person. This way I can request them to…
-
Having dates change by being linked to previous dates
Hello all, Ive looked and cant find this one ( or i didnt type the right thing in search ). I have several deployemnet dates set. Im wondering if I can have all dates change if I change one above them, EXAMPLE: On 03/14/17 I have a deployment scheduled. On 03/21/17 I have a deployment scheduled. On 03/27/17 I have a…
-
% Complete versus % Planned
Hi! I am trying to have two columns in my sheet: The original "% Complete" one and a "% Planned" one. It will help me check if my projects health is ok, by meaning if its percentage is above, equal or under the percentage of the project that was estimated for that date. I tried inserting a regular text/number column with %…
-
Task Name data not available from SSIS odbc connection
I have developed an SSIS package to read Smartsheet data, and then export the data into SQL database. I managed to export the data but noticed the Task Name, % Complete, Status fields are returning NULL values. This doesn't make sense because these fields are populated with data on Smartsheet. Please assist.
-
"Red" traffic light disappeared
Hi there, I'm currently using a "Red/Yellow/Green" traffic light status in one of my sheets, with the colour that is displayed being based on certain criteria. I've just noticed that the "Red" symbol does not show when it should (it was working fine before; "yellow" & "green" are still working ok.) I have not changed the…
-
Predecessors and Formula's Error when I delete rows
I have a master sheet that has tasks for all types of projects and depending on the customer we sign, I will go through and delete the rows I no longer need. The issue is that my RYG (error: #BLOCKED) and Predecessors (error: #REF) error when I do this which means I then need to go back and correct them manually Is there…
-
Auto row numbering not functioning problem
I created a new task list and set the auto row numbering in my first column, and set to document my tasks. Saved the sheet and then moved on to other things. The row numbering at this time is set correctly to 1 - 10 type of thing. I then went and added additional rows at the bottom and the dates and then wanted to sort the…
