How to update date in multiple formulas at once?

I am needing to update the date to be 2024 in all of these formulas (attachment) and so far I have just been going one by one (January through May) - but figured there has to be an easier way???



Answers

  • Tim C
    Tim C ✭✭✭✭✭

    Year entrey is fine on smaller scale or if you dont antipate change.I would instead reference a different cell for that potion that has 2023 in it. If you then get to 2024 and change the year in the formula, If the reference is looking at that one 2023 cell, then you change it to 2024 in the one cell and it changes in all of the formulas.

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

    Hi @crystal.schroeder

    I hope you're well and safe!

    • I recommend adding a Sheet Summary Field with the Year and referencing it in the formula.
    • What I usually do in my client solutions, which have Year, Months, Days, or similar, is to add so-called helper rows somewhere in the sheet (usually at the top) with the YYear in each cell, Month#, and so on, and I would still put the Year in the Sheet Summary and reference it in the Year row at the top)

    Make sense?

    Would any of those options work/help?

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic weekend!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

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

  • @Andrée Starå - do you have instructions on how to do that?

  • KenP
    KenP ✭✭

    For this I typically either use a helper row with the drivers needed for a sheet or a second drivers sheet and use cell linking to the other sheet.