=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!
Help Article Resources
Check out the Formula Handbook template!