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

  • Nick Korna
    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! 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!