each rows has different conditions, in a single cell ?

Options

each row has different conditions, In a single cell  I need to enter all the formulas for different levels of each row? please help me. Thanks in advance.


Answers

  • MichaelTCA
    MichaelTCA ✭✭✭✭✭✭
    edited 11/16/23
    Options

    Hello @kumars23

    Try this. It will look at different criteria for similar results.

    =IF(OR(AND(Level@row = "Level 3", OK@row = 5),AND(Level@row = "Level 1", OK@row = 3)),"Closed","")

    You can also use nested If functions like you have, but your syntax is incorrect.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!