Please guide

[mani_nsn]

Hi Team,


Need your help as I have got a requirement which will be of help for my current job.


The sample file is also attached along.


The points are as mentioned below:


1. In the attached xls sheet, the prominent columns are C,H,I,J and M.

2. When a new entry in numbers (any number of digits are fine) is made in the column ‘C’ , the corresponding column ‘M’ should get populated with “Unassigned”.

3. Next, when the date entry (any date format is fine eg: dd-mm-yyyy) is made in the column ‘H’, the corresponding column ‘M’ should get populated with “Pending”.

4. Next, when the date entry (any date format is fine eg: dd-mm-yyyy) is made in the column ‘I’, the corresponding column ‘M’ should get populated with “Offered”.

5. Next, when the date entry (any date format is fine eg: dd-mm-yyyy) is made in the column ‘J’, the corresponding column ‘M’ should get populated with “Joined”.



This would be of help as the fields may get auto populated as and when the date fields are entered. Let me know in case of any questions.


Thanks

 

[Khalid NGO]

Hi Mani,

I've not understand your requirement clearly:
Can you check this in M2:
=IF(ISNUMBER(J2),"Joined",IF(ISNUMBER(I2),"Offered",IF(ISNUMBER(C2),"Unassigned","")&IF(AND(NOT(ISNUMBER(C2)),ISNUMBER(I2))," Pending","")))

and inform ?

Regards,

 

[mani_nsn]

Hi Mani,

I've not understand your requirement clearly:
Can you check this in M2:
=IF(ISNUMBER(J2),"Joined",IF(ISNUMBER(I2),"Offered",IF(ISNUMBER(C2),"Unassigned","")&IF(AND(NOT(ISNUMBER(C2)),ISNUMBER(I2))," Pending","")))

and inform ?

Regards,

Thank you Khalid.

Can you please let me know what is the more information you require in this regard.

Just in a nutshell, let me summarise.

My requirement was as and when a prospective candidate is undergoing the hiring process in the company – there will be 3 stages which he/she will need to undergo.

1. Tech Selection
2. HR Selection
3. DOJ
4. Status

I was looking for an auto upgradation field update in column M is the “STATUS” field as and when the candidate progresses through each stage.

Thank you.

 

[mani_nsn]

Thanks Khalid. I checked the input provided from your side and it is working.

A small clarification required.

Once I put the input field in column C, the column M reflects the correct status as "Unassigned".

But when I update for the same row in the column H the status in column M does not get changed.

Please help.

Rest of the columns were fine.

Thanks.

 

[NARAYANK991]

Hi Mani ,

A small change is required ; the & symbol in the posted formula is a typo.

Try this :

=IF(ISNUMBER(J2),IF(J2>=I2,"Joined","Invalid Date Entry"),IF(ISNUMBER(I2),IF(I2>=H2,"Offered","Invalid Date Entry"),IF(ISNUMBER(H2),"Pending",IF(ISNUMBER(C2),"Unassigned",""))))

Narayan

 

[Syedali]

Hi Mani,

PFA, let me know if you have any clarifications.

Thanks

 

[Khalid NGO]

Thanks Khalid. I checked the input provided from your side and it is working.

A small clarification required.

Once I put the input field in column C, the column M reflects the correct status as "Unassigned".

But when I update for the same row in the column H the status in column M does not get changed.

Please help.

Rest of the columns were fine.

Thanks.

Thanks for feedback Mani...
Now something cleared.
Try Sir Narayan's formula in post # 5.