Creating an end date in a row...
I have created a Smartsheet with columns and would like to have column data automatically created in another column. I have unsure how or if I can make this happpen.
One column is titled "Start Date" and we have a date entered.
Another column is titled "Timeframe" and has a drop down box with selections "3 days, 5 days, 15 days, 30 days".
Another column is titled "End Date". Is there a way for the smartsheet to take the "Start Date" and whatever is selected from the "Timeframe" and place the date in the "End Date" column?
Answers
-
Hi @Donna G,
This should do what you're after:
=IFERROR([Start Date]@row + VALUE(LEFT(Timeframe@row, (FIND(" ", Timeframe@row) - 1))), "")
It extracts the number of days from the Timeframe and adds it to the start date. The IFERROR is just there to make things a bit neater by stopping an error appearing if a timeframe hasn't been added yet.
Example data:
Hope this helps, but if you've any issues or other questions then just post! 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!