-
RISK - Projects
Does anyone use Smartsheet for Risk Assessments / Risk Management? If so, What template do you use and what is your process? I've found on the link below several templates for Risk Management. However; when I download the excel and import it into smartsheet, the functionality is lost.…
-
Count number of specific characters in a string
Hi! I'm trying to write a formula that will give me the level of an item in a Work Breakdown Structure (WBS). The formula needs to read the number of decimals in a string. For example: * 1 = 1 * 2.12 = 2 * 3.1.14 = 3 * 2.1.1.1 = 4 * 2.327.1 = 3 The FIND function seems to be heading down the right track (by selecting the…
-
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…