Hierarchy Formula

DebRichardson

I am trying to create a formula to rank priority automatically. For some reason I am unable to make this work. Looking for assistance.

=IF(CHILDREN([Rank Priority]@2="Red",Priority@row1), IF([Rank Priority]="Yellow",Priority5, IF([Rank Priority]@row="Green"Priority8)))

Paul Newcome

It looks like you have some syntax issues to start.

[Rank Priority]@2 should be @row or the number 2.

Priority@row1 is the same as above.

The CHILDREN function should be closed after the cell reference.

[Rank Priority] does not have a row number or @row specified.

You are missing a comma after "Green".