Sum column total from another sheet if checkbox checked
Josh R
✭
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!
Comments
-
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
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives