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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives