Skip to content
  • Try for free

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    each rows has different conditions, in a single cell ?

    ✭✭
    in Formulas and Functions

    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.

    lvl.PNG


    · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      edited 11/16/23

      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.

      · Share on FacebookShare on Twitter

    Sign in
    Try for free

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions