Need help with an IF formula

Hi! I’m looking for help with an If formula. I want the end result to be:

  • If Column A says 5, then Column B will display “Now”

  • If Column A says 4 or 3, then Column B will display “Soon”

  • If Column A says 2 or 1, then Column B will display “Later”

The formula I used was: IF({Ranking (from Projects)}=5, “NOW :hammer:”, IF(OR({Ranking (from Projects)}=4, {Ranking (from Projects)}=3), “SOON :soon:”, “Later :file_folder:”))

But some of my fields with Column A that says 5, says Later. Do you know what I did wrong? Thanks!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.