Formulas

Kneve27

I have two cases where I need a formula to work for me

 

 

The first one is easy.  I have two columns - Delivery Date and Delivery Date (2).  I want Delivery Date (2) to automatically put the same date that is in Delivery Date in the corresponding cell.  I tried =[Delivery Date]1 but I get an error that says #number expected.  What does that mean?

 

Next question:  we create and send multiple deliverables before during and after a launch.  When we begin planning we create a T schedule where "T" is our go live date.  Then every deliverable is assigned a T + or - (in weeks).  So for example, if July 2 2016 is the date the system goes live, we may know that we want our field managers to know about the system go live date two weeks prior to launch (or T-2).

 

I have two columns: T+/- and Due the week of.  I would love for my sheet to understand what T is and then when the T+/- field is filled in with "T-3" or "T+3"), the Due the week of column is auto calculated.  Is that possible?

 

 

Thanks in advance!!

J. Craig Williams

Kneve,

 

1. Change the column type to "Date". The system is telling you it expects a number because Delivery Date (2) is a Text/Number type.

 

2. As long as [Due the week of] column is not a Project Dependency, you should be able to do that.

Does the date need to be "T-3" instead of just "-3"? Isn't the T implied in the column name?

If you are calculating [Due the week of], where is the base date?

 

For [Due the week of]

=[Whereeveryourbasedatecolumnis]23 + [T+/-]23

for row 23 would work (I assume haven't tested with those special characters, but I assume so)

 

If you need to strip out the '"T", check out the RIGHT function and the VALUE function.

 

Hope this helps.

Craig

 

 

JLC

Kneve, I told you there was a user named Craig who would know all of the answers - he's SO helpful!

J. Craig Williams

Jaye, you will make me blush.

 

Craig

Kneve27

Thanks guys!