If this then that...

Melody Walker

I am simply trying to create a formula that IF the job code is this, then it auto populates the corresponding Job Title into another cell. Is there a way to do this?

Automations 1

Hi @Melody Walker

This would be a basic If statement.

Assuming you want the job code of SUP to display Supervisor in the Job Title column, you would write the following in the Job Title Column:

=if([Job Code]@row = "SUP, "Supervisor"," ")

If you have a few different job codes you are working with, you would need a Nested If function. Such as:

=IF([job code]@row = "SUP", "Supervisor", IF([job code]@row = "Man", "Manager", IF([job code]@row = "DIR", "Director", " ")))

Automations 1

Hi @Melody Walker

This would be a basic If statement.

Assuming you want the job code of SUP to display Supervisor in the Job Title column, you would write the following in the Job Title Column:

=if([Job Code]@row = "SUP, "Supervisor"," ")

If you have a few different job codes you are working with, you would need a Nested If function. Such as:

=IF([job code]@row = "SUP", "Supervisor", IF([job code]@row = "Man", "Manager", IF([job code]@row = "DIR", "Director", " ")))

Melody Walker

Thank you! This worked!