G
Guest
Hi,
My manager has asked me to add some columns to our planning spreadsheet that
will allow us to easily see if another department is taking too long doing
its work. I need to create a fairly complicated IF formula, can anyone help?
I’ve added four columns to the sheet, these are as follows:
A1: Where now?
Using the validation function I’ve created a drop down box in this column
which has four options “Us checkingâ€, “To Artâ€, “To productionâ€, “Back from
productionâ€.
A2: With whom
This simply lists the name of the person within the production department
who is working on the document.
A3: Deadline
This column is formatted as a date and shows the deadline by which the piece
of work should be returned to us.
A4: Late?
This is the column I want to format. If A3 is empty I want this cell to be
blank. If the deadline in A3 has passed this cell should display the word
“LATEâ€. If the deadline has passed, BUT the drop down box in A1 is set to
“Back from production†then this cell should display the word “DONEâ€.
Can anyone tell me what this formula should be?
Thanks
Karl
My manager has asked me to add some columns to our planning spreadsheet that
will allow us to easily see if another department is taking too long doing
its work. I need to create a fairly complicated IF formula, can anyone help?
I’ve added four columns to the sheet, these are as follows:
A1: Where now?
Using the validation function I’ve created a drop down box in this column
which has four options “Us checkingâ€, “To Artâ€, “To productionâ€, “Back from
productionâ€.
A2: With whom
This simply lists the name of the person within the production department
who is working on the document.
A3: Deadline
This column is formatted as a date and shows the deadline by which the piece
of work should be returned to us.
A4: Late?
This is the column I want to format. If A3 is empty I want this cell to be
blank. If the deadline in A3 has passed this cell should display the word
“LATEâ€. If the deadline has passed, BUT the drop down box in A1 is set to
“Back from production†then this cell should display the word “DONEâ€.
Can anyone tell me what this formula should be?
Thanks
Karl