Formulas

Options
BenHolliday
BenHolliday ✭✭
edited 12/09/19 in Formulas and Functions

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.

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    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! 

     

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!