Formulas

BenHolliday

I want to create a formula in a cell that subtracts a certain number of days from another cell that is linked to another persons Smartsheet.  How would I do that?  My efforts have failed.

Mike Wilday

Hi there, 

This is pretty simple. After you have linked the cell... you can use simple math to adjust the days. For instance. If you have a linked cell in [Column2] row 3 and want to add 10 days to it. In a new column (set up as a date column) and row, use the following formula. Do note that because you are creating a new date you need to use the Date Column type to make that happen.

=[Column2]3 + 10

If you want it to be 10 days before that date use this formula

=[Column2]3 - 10

If you want it to be 10 working days after the linked cell date and you have set up your working days in your account settings.

=Workday([Column2]3,10)

Or 10 days before. 

=Workday([Column2]3,-10)

Hope that helps!