Assigning a date to a value

erin.pittman70676

I'm working on a gantt chart that is tracking teams progress on a project using agile development. 

Business Case / Background:

When the teams provide updates to when a task is going to be completed, they reference the name of the sprint we're in. So for example if "Task ABC" will be completed in Sprint 1A that means its end date will be 12/21/2018. I'd like to be able to have the sheet understand that the Sprint Name coincides with a specific end date. 

 

Issue:

I believe that I'm unable to have an End Date cell (if dependencies are turned on) be updated by a formula. 

If thats the case, I'm just going to use my calculated date field & manually update the official End Date using it. 

SO- how do I create a formula that says "If Sprint Name = 1A, then this field should say 12/21/2018"?

 

Thank you SO much in advance!

 

Andrée Starå

Hi Erin,

Try this.

=IF([Sprint Name]@row = "1A"; "2018-12-21")    

The same version but with the below changes for your and others convenience.  

=IF([Sprint Name]@row = "1A", "2018-12-21")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma. You probably need to change the date structure as well.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

erin.pittman70676

I'll give it a try right now! Thank you  

Andrée Starå

Great!

Happy to help!

Best,

Andrée

erin.pittman70676

It worked! Thank you again for the help!

Andrée Starå

Great!

I'm always happy to help!

Best,

Andrée

Paul Newcome

Out of curiosity... How many of these different dates/sprint names are you using? If you are using quite a few and are trying to reference them all, it could become a VERY lengthy nested IF statement.