Assigning a date to a value
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!
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I'll give it a try right now! Thank you
-
Great!
Happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
It worked! Thank you again for the help!
-
Great!
I'm always happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!