I need help with the right "IF" or SUM IF formula
I want the formula to do a few things.
1  Check to see if the row has CHILDREN and if it is a "Rollover PO"
I have a helper column that is "CHECKED" if it is a parent I also have a column for "Rollover PO"
2  If both are checked THEN I want the formula to SUM the CHILDREN in column [Total PO Spend]
3  If the column [Rollover PO] is not checked, I want the the formula to return the value in column [Invoice Amount] in the same row.
My attempts continue to return an UNPARSIBLE result. Am I asking too much or do I have the formula all wrong?
=IF(AND([Parent]@row, [Rollover PO]@row, 1), SUM([Total PO Spend]CHILDREN()),IF([Rollover PO]@row, 0, [Invoice Amount]@row))
Thanks,
Michael
Best Answer

Hey @M Scrog
Just a few adjustments to get the syntax right in the formula.
=IF(AND([Parent]@row=1, [Rollover PO]@row=1), SUM(CHILDREN([Total PO Spend]@row)),IF([Rollover PO]@row= 0, [Invoice Amount]@row))
Does this give you the expected results?
Kelly
Answers

Hey @M Scrog
Just a few adjustments to get the syntax right in the formula.
=IF(AND([Parent]@row=1, [Rollover PO]@row=1), SUM(CHILDREN([Total PO Spend]@row)),IF([Rollover PO]@row= 0, [Invoice Amount]@row))
Does this give you the expected results?
Kelly

Thank you @Kelly Moore ! It worked beautifully!
Michael
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!