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
Check out the Formula Handbook template!