-
How do i add more than one duration to a gantt chart?
I have a project that has hundreds of tasks. Each task has a fabrication duration and a delivery/logistics duration. How can i add an extra column and add the extra duration per task to show in the gantt chart in maybe a different shade or different color? The other solution, would be to add a line below each task just for…
-
Auto-Refreshing Sheets/Grids
Hello all, In m company, managers have to perform monthly audits of the plant floor. I created a system that should email them weekly notifications describing where they should be performed and who to talk to. The sheet has a week column that I'd like to automatically refresh without having to go in and manually do so. Is…
-
Graph widgets not working today
I have been using the Dashboard for some time, with various widgets. Today my graph widget show MISSING SOURCE. Yet when I go into edit mode, I see the data, and when I create a new one, and save it, I get the same code. I check others reports from other users, their graphs are working.. What has happened.. I tried on my…
-
Percentage Complete Calculating Differently on 2 sheets
I have a smartsheet that is pushing data to another sheet. Percentages complete are part of the data that is being pushed. On the source smartsheet it shows 45% for a section. On the Target sheet it shows 63% complete for the sames rows. Can anyone explain why I am getting 2 different percentage completes calculated?
-
Countif on filtered list or a range based on a value on another column
I use the following function to count "=COUNTIF({Cell Range 2}, 0)" numerical values from a column. However, I should only count the cell values when a cell value in the same respective row but in another column is blank. Not sure how to proceed.
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Formula from hell
I have ranges of data in multiple forms. There is criteria that must match from each to be summed on a third sheet. The criteria are GL Accounts and a month Code. One of the month codes is listed as 12 Month. The intent of that code is to signify that the cost in one of the columns should be spread across 12 months. So I…
-
Sorting Issues
I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any difference) This morning we SORTED several rows and HOURS later someone who had the sheet open, saved their data and INSTANTLY ALL…
-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
-
Back calculation of dates in Gantt View
Hi there, I'm building a schedule in Gantt View by back calculating from an end date. The issue I have (refer attached screenshot) is that I require the finish of the task at row 353 to be the earlier of the start of row 355 or 2 x weeks prior to the start of row 32. When I put in what I understand these predecessor…