Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
auto populate start date based on sprint number OR vice versa
Smartsheeters,
I am looking to auto-populate start date based on entering a sprint number. OR to auto populate sprint number based on start date- I assume that finish date will be auto populated based on duration entered (10d).
I am fairly new to smartsheet so keep that in mind
Any ideas? or Articles to share?
Thanks,
Megan
Comments
-
You might be able to adjust the sprint number based on the dates. But the start date / finish date, etc cannot be adjusted with formulas.
You could in the sprint column create an IF statement that creates the sprint name but without knowing more detail it would be difficult to guide you.
-
If you are using a sheet without Dependencies enabled, you can use a formula for the [Start Date].
However, you can not have a system using the GUI that allows both options - enter date or sprint # as the formulas will be overridden and lost when someone enters the data manually.
I have built system that provide such flexibility using Zapier (www.zapier.com) where the person can enter the [% Complete] = 100% or check the [Done] column or set the [Completion Date] to a date ... and the other two are automatically filled in.
Craig
-
Thanks for the suggestions! I am currently investigating an integration with TFS (our devs use that to manage sprint work and backlogs). I am hoping that I will be able to import that information from work items.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives