Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Sumif with child based on criteria of other column?
I'm needing to get the SUM amount of dollars from the "Budget" column if that row is a "1" in the Quarter column...the rows are children...please help?
Tags:
Comments
-
Dear Gerson,
try this: =SUMIF(Quarter:Quarter, 1, Budget:Budget)
Atus
-
You are the man! Thanks :-)
-
Actually...Atus - when I try to sum if the quarter cell = 2 it ruins the other totals and nothing works... :-(
-
Saying its a circular reference
-
It's all right - got it working. THanks,
-
good to hear
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
