Brian W’s Profile

Community member since September 2018

points
187

6

Hello!

I would like for the RYGB status to be updated based on BOTH a due date (I already know how to do the status based on only due date), AND on the selection of a drop down menu in 5 other columns.  

So:

Red is past due AND "completed" or "N/A" are not selected in the drop down menu in multiple

3

I am trying to Sum up the parent rows and am getting an "Unparseable" from my formula. Here's the formula. Please let me know what I am doing wrong. I have tried 1 to 4 closing parentheses as well. Same thing. 

=SUM(PARENTS([ST Rev ($)]5:[ST Rev ($)]65)