Link to another sheet and add additional days

Ridix
Ridix
edited 12/09/19 in Formulas and Functions

Hi there, 

I am trying to link to a master schedule but adding some additional days to define my drop dates. 

Please help. 

Thanks. 

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi,

    Are you using cross-sheet formulas or cell-links?

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Hi Andree, 

    I am using cell links. I have one sheet which I want to link to another sheet but want to add some additional days to my sheet while maintaining the Link to the other sheet. 

    I tried this formula in my sheet:

    =({mastersheetlink} + [15days])

    But it doesn't work. 

    Please help. 

  • Hi Andree, 

    I just tried this formula and it work within the same sheet. I am trying to link my date to another sheet is my whole point. So that if the other person on the other sheet changes her date, mine automatically calculates my new date and updates it. 

    =[Source Data Cell] + [Desired Number of Calendar Days]

    Let me know how I can change the source data cell to link to another sheet?

    Thank you, 

    Ridix

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Happy to help!

    When cell-linking, you can't do anything with that value in the same cell so the solution would be to add a column for the cell-linked value and then do the calculation as needed in the main column.

    Another way to structure it would be to use a cross-sheet formula instead and then it would work in the same cell.

    Which method would you prefer?

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!