Creating an end date in a row...

Donna G

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?

Nick Korna

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! 😊