Linking a cell (date) to another sheet and adding extra days to in Smartsheet


Hello Community,

I need to link a cell to another cell (different sheet) and also add extra number of days to the value in the cell. What is the best way to go about this.

The cells are dates, for example

Sheet 1 has cell A = 12/05/23 needs this cell needs to be imported to Sheet 2 cell B plus 10 days.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!