I have several sheets that I need to pull data from to sum in a master sheet.
Is this possible?
Yes, it is. You can do it in several different ways and the right one depends on your specific set up. Can you share the sheet(s) or some screenshots?
You could use cell-linking or cross-sheet formulas.
Please see the attached link/screenshot.
I hope this helps you!
Workflow Consultant @ Get Done Consulting
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.
Thanks for your reply.
But I need the numbers that I have copied from the cells to be summed in teh master sheet.
For example in Sheet 1 I have 6 cells with numbers that I want to appear as 1 cell - summed up - in the Master.
is this possible:)
Happy to help!
Yes, it is. The best solution depends on the structure of your sheet. Can you share the sheet(s) or some screenshots?
For this you would want to use a basic SUM function with x-sheet references (Andree's second link).
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
I would say that it depends on which cells are needed in the sum. If they ain't connected and spread out in the sheet, I would first cell-link them to another "Master sheet" or sum them inside the main sheet.
Good thought. I just assumed they were in a single row or column.
I did at first also
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
I am a business user but Data Shuttle is not activated. How to activate it?
Hello I am trying to calculate a sheet summary field to show how many times a value appears in the Location column. I am using the Count if function but it is only returning a value when the "location" is presented on it's own. For eg: my formula is =COUNTIF([*Location]:[*Location], "VIC"). This formula responds with a…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.