Auto Populate Date

We are currently creating a sheet to track assets that are provided to employees as a loaner.

We created 2 date columns:

  1. Primary Date column automatically records the date once the sheet has who the loaner is assigned to
  2. Second date column is where we want a date to be recorded based off the 1st date. This date would be 7-days from the date recorded in the column above.

Is this possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!