-
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?
-
How to define a default value for a field with a formula
Hello Guys, I am using the webform feature to create the new record for my sheet. In each record, I have cells called Created Date, Closed Date and Duration. And the Duration is equal to a formula which count the gap between Created Date and Closed Date. f(x)=NETDAYS([Created Date]1,[Closed Date]1) The formular is working…
-
calculating changes to duration value
I need to build a formula to calculate changes to the default duration value within our master timeline template. Ideally, I need to the function to notice a change to the default value and calucuate the increase or decrease. Any suggestions on the approach for this?
-
Column Names - Tips and Tricks
1. Naming Columns: Changing a column name post-facto breaks reports and other stuff creating a lot of useless donkey work. Naming columns correctly at the get go is uber-important- think about it before comitting. 2. Make your formulas easier to read: Name columns with underscores between words, i.e "Due_Date" instead of…
-
Monday of date
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
-
Formula to calculate start date, from end date
Hi SS community, I am trying to write a formula to provide a date, 45 days prior to the start date. Ie. = [Start Date]1 - 45days Appreciate the help.
