Estimate End Date, Actual End Date, Adjusted End Date flagging

For my projects I track Estimated/Actual Start and Estimate/Adjusted/Actual End dates. I need to have a status flag indicate yellow if the Adjusted date is slipping past the estimated end date, and then when the end date is adjusted and justified, to update the status flag back to green.

Is anyone tracking like I am? Do you have a formula that works for you that you'd be willing to share?

Find more posts tagged with

Formulas

Project Management

Comments

rjudenberg

if(adjusted>estimated_end,"Red", "Yellow")

Michele Deo

Thank you, but I forgot some elements in the formula. If the adjusted end date is greater than 90 days passed the Estimated End day, then highlight the Project Name in Yellow. If it's later than 90 days passed then turn project Name red.

I think I can get this, but not sure, but would it be something like...

if(adjusted_end_date>estimated_end+90, Project Name="Yellow", (if(adjusted_end_date>Estimated_end+100, Project Name="Red")))

Is that right?

rjudenberg

syntax looks ok.

you originally said you wanted a status flag. If so then this code goes in the status flag column

if(adjusted_end_date>estimated_end+90, "Yellow", (if(adjusted_end_date>Estimated_end+100, "Red","Green")))

if you want to change the color of the project name, do this in conditional formatting (and then you don't need the part about the colors), you just do the condition and then select the formatting

Sign in to join the conversation!

Quick Links

Trending discussions

seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…