Forum Discussion
If function in tracking status of my milestones
SergeiBaklan Ok, D22 is cell I'm trying to work my syntax on. To me its a template until I place it in B3 and spread over the column. The reason its working on Order# 6 only is because I took that order as an example for myself while trying and trying to figure how can I get my milestones dates connected to this status cell. Hence, B20 and the column associated will be totally replaced.
You see I want to have my milestones placed as:
Order Status: With Sales, PR Pending, PR created, ...., Check Recieved
Instead of order status: Open, Closed Disputed (the drop down list)
The idea for doing that is to have my management realize in one snapshot that where my orders are in terms of milestones.
Shipment in transit is W20, when I put my date there, the status should reflect, "Shipment in-transit"
Thanks
I see, thank you, that was not easy to make a guess which columns to take. As variant formula could be
=INDEX($F$21:$F$29,
1+
(E20>1)+
(L20>1)+
(T20>1)+
(V20>1)+
(W20>1)+
(Z20>1)+
(AA20>1)+
(AC20>1)
)Please see in I22
- Many thanks for the response. I was also hoping if no dates are placed in “hand over date from sales” column the cell reflects “With Sales” as default
Can you please help there as wellIf no dates in this and other columns, above formula returns With Sales
Or you mean something else?
- Yes I meant precisely that
Thanks Sergei