Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
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
