Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Need help with an IF formula

Topic Labels: Formulas
232 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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