Hierarchy Formula

DebRichardson ✭✭✭✭
edited 12/15/22 in Formulas and Functions

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)))

Deborah L. Richardson

Executive Assistant

Office of Research Operations

Tel (603) 650-1801 | Deborah.l.richardson@hitchcock.org

Dartmouth Hitchcock Medical Center


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!