Can smart sheets handle a sumif across different sheets? I want to do something like this.... In sheet B: SUMIF (range in sheet A, where the task is the same as task in sheet A, add all the hours in sheet A) - should return total hours where tasks are the same. This is difficult to describe - please advise! :)
