I am trying to create a project rollup cell based on the values of the values of the subtasks under the main task. The formula I'm using is:
=IF(ISTEXT(MATCH("Need Help",$F3:$F7)),"Need Help",IF(MATCH("Some Issues",$F3:$F7),"Some Issues",IF(MATCH("On Track",$F3:$F7),"WTF?")))
My data set...