That's Brilliant
The Rules are:-
if we receive some information: M should be updated from Blank to Yes (however sometimes this is not applicable hence NA)
If yes and now NA then The formula in N shows nothing
If M is blank and the date of installation (P) is within 7 days then N shows Check...
I have a big tracking spreadsheet that adds new lines to the top and copy cells but collegues keep deleting a cell because it wasn't right on the previous row
I have this Formula =IF(AND(P9<>"",P9<=$B$3+7,M9<>"Yes"), "check with Barry", "")
However in M9 there is NA which is returning check...
I have implement this
=IF(AND(P6<=$B$3+7,M6<>"Yes"), "check", " ")
which seems to be working, However how can I change it that if P6 is Blank then still " " ?
so in N if P is empty do nothing
I need to be able to instantly know of a project is at risk by not receiving details within 7 days of install
I have added an example
In column N, I want it to show "check"
if the install date in P is within the next 7 days (and gone past the date in P (if possible)
of M does not say Yes
I...
I have a spreadsheet that I track all the orders for one customer
Each time we have an new order we have a macro that copies Row 6 and inserts a new row 6 and pastes it back in clearing the contens from the main section see Sub AddNewProject()
This works fine, however counting up items in...
I should be able to work this out but failing miserably
I have provided an example and a description
if v (Status is In Progress) and E is (Client owned) in x (Client owned Tills) and Y (Client owned Printers put in F(Qty)
otherwise it would be zero
V could be Completed, Hold, Place Holder...
quick example
So if C2 = 1 then c6 is 1
if C2 >=2 <5 then C7 =1
if C2 >=5<9 then C7 =2
if C2 >=9 <12 then C7 =3
if C2 >=12 <15 then C7 =4
if C2 >=15<18 then C7 =5
if C2 >=18 <21 then C7 =6
I hope that helps
I have an order sheet that automatically calculates the labour days based on hardware installed
so if I have 1 we can do in a ¼ day and therefore I have an order line for ¼ day and a formular =IF(D172=1, 1,0)
if more than 1 we charge ½ day and the forular on ½ day is =IF(D172 >=2, 1,0)
However...
https://www.dropbox.com/s/51o4ew6bsvli9zh/Customer%20Contracts%20for%20Chandoo.xlsm?dl=0
Above is a link to the file in Dropbox, its too big to upload
So let me explain what I do:
Each month I filter, using KUTOOLS super filter the relevant month, So now I am looking at Filtering month = 8...
I have a Workbook with 143 worksheets on it
2 worksheets are for reference ("contract Look Up" "All contracts Feb 2021" " Key" ( more of these could be added or names changed) (if it helps these have tab colours Purple from the standard row)
all of the other worksheets have no tab colour at...
Good Morning Vletm,
I appreciate your help. I didn't read all, for that I apologise, I jumped to conclusions that is wrong.
so I can work with this and to get the new copy each week we can delete the rows already filled in and then each week starts again
because the code is locked I can not...