SUMIFS Based on Children
I use Smartsheet as a future revenue reporting tool.
I have a total at the top for individual managers, formula for total is a SUMIF function.
Formula is =SUMIF(CHILDREN(WAM$8), WAM1, CHILDREN([Est Revenue]$8))
WAM 8 is our total for everyone section, WAM1 is for individual managers, Est Revenue 8 is our total Est Revenue.
We use a Confidence Level row in our database as well, delineating work that is either +80%, or Below 80.
I am trying to use a SUMIFS Function underneath the total for each of our managers, so we can see instantly what work is +80%, or below 80. My end goal is to have 2 items underneath each manager at the top, showing +80% value and Below 80 Values.
Help Article Resources
Check out the Formula Handbook template!