Formaula

Hi Brain Trust :-)


Cant get my formula to work - basically want it complete + Gree, In Progress = Blue ... ect BUT if my Admin column is checked I want it to be blank


cant figure out what I have done wrong :-O

=IF(Admin@row = 1, "Blank", IF(Status@row = "Complete", "Green", IF(Status@row = "In Progress", "Blue", IF(Status@row = "On Hold", "Yellow", IF(Status@row = "Not Started", "Red", "")))))

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Susan van Niekerk,

    please try the following formula:

    =IF(Admin@row = 1, "", IF(Status@row = "Complete", "Green", IF(Status@row = "In Progress", "Blue",
     IF(Status@row = "On Hold", "Yellow", IF(Status@row = "Not Started", "Red", "")))))
    

    the screenshot shows the result


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!