If function for priority

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!