Brian W’s Profile

I am trying to count based on 2 criteria if checkbox is checked. So far it only returns a zero value when the checkbox is checked. Here is what I have...

=COUNTIFS({Real-Steel Estimator Review Total Loss Tes Range 1}, "true", {Real-Steel Estimator Review Total Loss Tes Range 2}, Appraiser5,

Hey all.

I am trying to have a column search a series of columns and return the data from the column that is not blank.

I have started with the following:

=IF(NOT(ISBLANK([Title:]1)), [Title:]1, [Peer to Peer Program Title]1)

Which checks the Title column, and if not blank returns the data from

Needing a formula to turn Harvey Red, Yellow, and green.

If sold box is checked = green. If Quote Submitted day is over 14 days, AND sold is NOT CHECKED = yellow. And if Quote submitted date is over 30 days past, AND SOLD is not checked = red. 

I have the green part correct 

=IF((Sold@row = 1,

We are having a problem with links not updating between sheets. Is anyone else having this

I am trying to write a date range formula with an IF AND statement (I think). 

I need to check a box if [Previous date] is in a specific date range.

Whenever I change a field to NA it should exclude counting it into the average but it is not doing that.  It is staying at 50% but should be 100%. Please let me know what I need to do. See screen shot.

=(SUM(Yes4, Yes6)) / ((COUNT([Department - ie: Sales Eng, TDE's etc]4, [Department - ie: Sales

Been playing with this for a while but can not seem to get this right.

Any help would be appreciated

=COUNTIFS({Editing List-3-2018 Range 2}, >=(DATE(2018, 7, 1), {Editing List-3-2018 Range 5}, ="Name"), Date:Date, <=(DATE(2018,6,30), [Assigned to: Editor]:[Assigned to:

I'm really struggling to get the syntax right on this.  I have a column called "% Complete" and a due date column called "Finish."  If the % Complete < 100 and the due date is today or already passed, I want to turn on a flag in the "At Risk" column.  Ideally I'd actually like to flag it if the due

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

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)