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!