Help

Need help with an IF formula

Topic Labels: Formulas
489 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jenny_Chen
4 - Data Explorer
4 - Data Explorer

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!

0 Replies 0