-
Keeping persistent dates for status changes
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
-
Contact List Cell-Linking?
Does anyone have a work around for cell-linking a contact list column that is used to calculate Resource Management and Conditional Formatting without creating another column? Issue - Person assigned to Task A needs to automatically be assigned to Task Z.
-
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,…
