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
- Smartsheet Customer Resources
- 62.2K Get Help
- 358 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!