-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
Average formula for cell values calculated from another formula
I'm using the SS Jira connector for Jira and have create a template for my team to use. As part of this template I want to calculate the % completed field based on the task's status (the built in % complete of the gantt project only work at the parent level after manually inputing a value for the child task). I've been…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
-
Tip / Tricks - Simplify Date Management w "Days from Today" calculation.
Looking at long column of dates is cognitively challenging, but everyone understands a range of numbers, negative to zero and then positive. I originally used this scheme to simplify my conditional formatting setup but found that users really liked it so now I keep it visible. It also makes reports much easier to…
-
Automating swim lane changes in Card View
Does anyone know of a way to automate moving a card/task that has been set to 100% complete in the % completion data field into the "Complete" column / swim lane in the Card View (or for that matter, automating any swim lane change in the Card View based on any task data parameter)? Currently it's a manual process of…
-
Formula for capturing the date when the status column change
Hi, I have a completion date column. I want to know if there is a formula I can capture in the date column to indicate that specific date when the Status was changed to complete? Please help. Yovanka
-
Parent Relation on Progress %
Hi, i am trying to figure out how to create a parent relationship using the progress bar (0%, 25%, 50%, etc...) without having to enter 2 dates. I have a parent with 6 children rows under it. If i choose the progress bar as a colum property from symbols and select progree in the 6 children, I want the average to be…
-
I just Cant Seem to figure this one out help please.
Ok In the picture Below Cell ?:? is going to be a drop Down List pulled from a drop down list on a web site. Action wanted : * After I figure out how to link the Drop Down List in F20. * I would like to create a new Row above row 26 and Insert the Drop Down List Slection into B25 instead of in F20. * * Cells…
-
Issue Calculationg Actual Durations
I have a project sheet where i added an actual start and actual finish. I also added an "actual duration" column, which is a calculated field. In that column is the following formula: =NETWORKDAYS([Actual Start]2, [Actual Finish]2) The problem is that in some cells it is showing a huge value. There isn't a rhyme or reason…
-
Basing a count formula off of the current date for the day
I am trying to create a formula where I can total up certain fields each day. Does anyone know of the formula that would allow the use of today's date in a countifs situation?
