If function for priority

Hannah Huffman

Hello, I am working on trying to come up with an IF function for priority. An example would be IF the cell is high priority (Red exclamation point) then the number 1 is given, but if it is medium priority (Yellow line) 2, or if low priority (Blue down arrow) 3 is given. These flag images can be changed if needed, it was just how the lane was originally set up.

High priority =1

Medium priority =2

Low priority= 3

Jon Baier

Something like this?

=IF(Flag@row = "High", 1, IF(Flag@row = "Medium", 2, 3))

Hannah Huffman

Yes! Exactly that! Would I need to put Low in there for the 3 to relate? I am much more used to excel functions and I have only used smartsheets for about a week so far.

Thank you for your help.

Jon Baier

Nope - the final 3 in the formula will be applied when the 'IF' statement fails on the 1 and the 2.

Hannah Huffman

I am getting a error of #UNPARSEABLE, what do I need to edit?

Jon Baier

The IF statement is in each cell of the Priority column. Make sure you change the column names in the formula to match what you have them named on your sheet. When I get UNPARSEABLE errors, it's usually because of a)column names, b)missing comma or parentheses, or c)missing argument to a function.