Bulk Cell Linking

I have a sheet with the Monday-Friday and a weekly total at the bottom of each week. I want to cell link each weekly total to another sheet, so I am trying to link every like 5th or 6th row, depending on how many weeks are in that specific month. Is there a way I can mass link these instead of doing each cell individually?


Answers

  • Hi @Whitney F.

    Is there a reason this needs to be a separate sheet? What I would do in this instance is create a Report and filter if the row says "Weekly Total". That way you'll automatically see all Weekly Totals in one view.

    If your column on the left is a Date column, an alternative would be to use a SUMIFS Function in a cross sheet formula instead of manually cell-linking.

    You can set up a Start Date column and and End Date column in your Metric sheet, then SUM the total column based on the dates.

    =SUMIFS({Total Column}, {Date Column}, >= [Start Date]@row, {Date Column}, <= [End Date]@row)

    Let me know if that works for you!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now