Autofill field using the IF function

etenenbaum · 09/25/19

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å · 09/25/19

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

Comments