I want to apply a formula so that when a value is greater then 9, it should mark the initiative as high priority, 6-9 be marked as medium priority and less then 6 is low priority.
The most letest formula i wrote is:
=IF([Priority Score Final]@row > 9,"high",IF([Priority Score Final]@row >6,"medium",IF([Priority Score Final]@row <9,"medium",IF([Priority Score Final]@row <6,"low","medium))))
But its not working and i am getting an error #UNPARSEABLE
