# Brian W’s Profile

points
403

I'm trying to total up the job value column based on weekly totals. Can I have the formula calculate the weeknumber or do I have to create a helper

Hello,

I hope someone can help me.

Maybe I'm blind, but I can't find a way to make a Report for only yesterday,

I work on a big sheet (> 4,000 rows, 25 columns) with many different days in the column [Datum].

Now I want to make a report, that shows only the rows from yesterday. Not today, not

I'm writing a COUNTIF formula referencing a column with multiple values that works well, until I try to build an expression that says:

I want you to count the values in this column as long as they are NOT "x" OR "y" OR "z".

Can anyone help with the proper syntax?  I've tried the following but it

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