Brian W’s Profile

I have 3 columns: Planned Date, Completed Checkbox, Late

I want a formula to put "Late" in the (Late Column) IF the (Planned Date) is passed and (Completed) is unchecked. If it is not late, I want to leave the Late cell blank.  I want this to show on every row. 

Here is my formula for row 2.  I'm

Hi everyone. I'm trying to come up with the best way to count the number of days that a project is being worked on in a particular week. You can see in my screenshot that ProductiveDays is counting the working days from 6/10 to 6/14.

I've come up with a rather cumbersome formula that works and only

I'm trying to sum monetary amounts for a certain customer while referencing the data from a separate sheet. However, I only want to sum those amounts that fall within the FY20 (fiscal year) dates of 4/1/19 to 3/31/19.

Here's the start of my formula that sums all dates, but what conditional formula

Hi,

I've had a search through the community but I can't seem to get a working formula so hopefully someone can help me.

I'm trying to count if Issued Date is not blank and Responded Date is Blank. 

=IF(AND(NOT(ISBLANK([Issued Date])), [Responded Date] = ""), 1,

Hello All, 

I am trying to nest a criteria within the LARGE function. I have 2 levels of children within my sheet and I have placed a hierarchy column so I can select just the children with a hierarchy ranking of "2" for the LARGE function. My formula below, but it is throwing errors. Any help

Good Day,

We are struggling with getting a "Years in service" calculator to work, after having pulled all the formulas that could be found by previous posts, still no luck.

=IF(AND(MONTH([Start Date]1) >= MONTH(TODAY()), DAY([Start Date]1) > DAY(TODAY())), YEAR(TODAY()) - 1 - YEAR([Start Date]1),

This is my formula:

=IF(AND([Scheduled Complete]6 < TODAY(), [Document Added]6 = 0, Complete6 = 0), 1, 0)

Not sure what i'm missing but as soon I check the box for document added it clears my flag. I don't want the flag to clear until all three criteria are

Trying to get data from one sheet to another by matching on Deal ID

to the Requests sheet from the Salesforce sheet

Could someone please help me for the formula for this?  this would be an import from salesforce that I would have to do manually weekly, so I could rename the imported file and use

Hi All,

I am trying to create a formula (assuming a combo of if/or is the way to go), but keep getting "incorrect argument set. They work independently, but not when I combine them. I basically want to search for either of the following in a cell and then return a value.

Look for any of the

Hello, 

I am looking for some assistance with how to write a formula that will auto-fill a check box. I only want this checked if the Parent Cell column is blank and that the Assigned to is equal to the user. Currently, the formula I use auto-checks is the Assigned To contains the user's name. Any