Need help!

JoshR

=IF((CONTAINS(CHILDREN([STATUS]), "On Hold"))=SUM((CHILDREN([AVAILABLE FOOTAGE LF.])):(CHILDREN([AVAILABLE FOOTAGE LF.])))

Hi all, need some help with my smartsheet. I'm trying to add the total, under the parent row, in the "Available footage LF." column if "Status" column is showing "On Hold". I tried the above but it doesnt work. Im no expert just need some help, if its at all possible. Thanks!

David Tutwiler

You can't do two different functions in the same line together. Good news is that I think you're looking for the function SUMIF. So something like this should work:

=SUMIF(CHILDREN(STATUS@row), "On Hold", CHILDREN([Available FOOTAGE LF.]@row))