Autofill field using the IF function

etenenbaum

Hi

I have two columns. One is called "Hierarchy" and the other is called "Description"

I'd like to have "Description" automatically filled with this text/forumula "=PARENT()" if the value in the Hierarchy column is "2"

Can this be done using the IF function or through another method?

Thanks

Andrée Starå

Hi,

Yes, it is.

Try something like this.

=IF(Hierarchy@row = 2; PARENT())

The same version but with the below changes for your and others convenience.

=IF(Hierarchy@row = 2, PARENT())

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD