Dave Godfrey’s Profile

Community member since June 2018

points
51

4

Hi everyone,

 

We're putting together a stock sheet and we want to create notifications so that when a figure in a cell drops below a certain amount an email is automatically sent to the relevant people so they know to re-order.

 

Can anyone help please?

 

Many

1

I am trying the set up a dashboard using a rollup sheet.  

I am trying to automate the start date so that it is always set to the 1st of the month or would it need to be manually changed every month?

Thanks

5

Hi all,

I am running into an issue with using CountIF and AND. What I am trying to do is count the number of times certain text appears within a 90 day period (based on submission date which is a date column). 

=COUNTIF(AND({External Range 1}, "Zebra", (TODAY() - {External Range 5} < 90)))

I am

5

I am trying to work out the average number of days quotes are being taken to be submitted.

 

The columns i am working with are Enquiry Date and Date Quote Submitted.

 

I have done a Sum formula to count the number of days taken (=SUM[Date Quote Submitted]1 - Enquiry Date]1

 

but because not every

4

I have a sheet with a lot of data on it and I am wanting to get a count of the number of jobs that have been completed after a certain date.  I have managed to create the formula below which allows me to get a count of the full sheet

=COUNTIFS({QinetiQ Actual Completion Date}, >=$[Start Date]$3,

1

I wonder if anyone would be able to help me.

 

I am trying to collate some data that allows me to give a count of a number of jobs that have missed a target date.  The sheet I am working on also has 2 different cost centres and I would like to break this data down so that I can see the data for each