Sum column total from another sheet if checkbox checked

Hi, I've seen this done on same sheet but I'm having trouble accomplishing my goal trying to pull from another sheet.

What I'd like to do is on "New Sheet 1" have the "Done" Column total update from the "To Do" Column from "New Sheet 1b" when the checkboxes are checked.

Thanks in advance!

Capture Smartsheet 1.JPG

Find more posts tagged with

Comments

Josh R

Here's how it looks on the same sheet:

=SUMIF(QC1:QC3, 1, [To Do]1:[To Do]3)

I haven't been able to reference the 2nd sheet to make this work yet

Paul Newcome

There are a couple of ways to do this. You can either do the match on the source sheet and use a basic cell link, or you can use formulas with cross sheet references.

Just click on the text for each of the options for more information on how to use them.

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…
True up and the admin center
Hello We converted over in July to the usm. We have alot of discrepancies where people are in usm and not the admin center and vice versa. Is anyone else see the same and feel this is an issue? Also, I would like to brain storm with the group as to how procedurally you will be doing the true up process and terminations as…