-
Is it possible to develop a task list from multiple source sheets through automation?
We are creating new courses and content for our LMS and we want to use a project sheet to track all the tasks associated with developing the course and its respective content from beginning to end. We have a handful of different "Learning Object" types that each have their own repeated tasks or activities to develop and…
-
Triggering a Workflow on existing data
Hello, I can't seem to figure out how to trigger a new Workflow on an existing data set. I created a Move Row Workflow that is triggered by a change in my Status column and where there is a date present in another column (two conditions). I am having to change the Status from Completed, save it, then change it back to get…
-
How to best pull data from a matrixed sheet of dates and milestones into a project sheet?
I have a team that is updating date estimates in a large sheet. I'm looking to create a project sheet from that matrix/range. I'd like generate the sheet with links at the same time so that when the team revises dates in their sheet the project sheet updates as well. I don't want to have to manually create Column A entries…
-
How to count the times a person is assigned to a defect status
Objective: Have dashboard that reflects defect status and who is assigned to it, if blank then "Not Assigned" Example 1 Jake has three defects assigned to him. 2 = "Intake" 1 = "Vendor In Process" Example 2 Eric has 5 assigned to him 1 = "Resolved"; 3 = "Ready for Retest"; 1 = "In Process"; For any defects not assigned,…
-
Automatic Linear Percentage Complete Formula
Hello, I am wondering if you can help. I currently use Smartsheet for project planning. I would like to build an automatic percentage complete formula. This formula should work off a linear progression line from Actual Start Date to Baseline Finish Date and the duration. So an example of a task would be: Actual Start: Now…
-
Smartsheet count function
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to count that line?
-
Is there a way to pull the baseline start & end dates from a project sheet?
I am creating a project status dashboard that will encompass all of our projects. It's simple enough to link each line to a project but the thing I want to be able to grab is the baseline start and end dates from the project. Short of scanning a column and finding the lowest and highest numbers, is there a way to access…
-
SPI and PLnned Value % in Smartsheet
Hi Everyone, I'm dealing with implementing Earned Value Management in our Project Portfolio as stated in PMI PMBOK guide.. However, I am not sure yet in how to calculate the % of Completion Planned for the whoe project as well for each activity since the new functionality of baseline in projects calculates for each…
-
Is there a way to identify and highlight that a particular contact has overlapping dates?
Staff assignment sheet I want to be able to highlight rows that have the same person assigned to overlapping dates. Assignment is a Contact list dropdown and the dates is a Date column.
-
Counting distinct values with two conditions
I am trying to count distinct items that fit two conditions, but I'm getting back an error. Here is the formula I was trying: =COUNT(DISTINCT(COLLECT({My Sheet Range 1}, {My Sheet Range 2}, CONTAINS("SEA", @cell), ({My Sheet Range 3}, CONTAINS("In Progress", @cell))))) If I remove the second condition or use only the…