Skip to content
  • Try Smartsheet

    • 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.

    Change Status based on Checkbox

    ✭✭
    in Formulas and Functions

    I'm new to smartsheet and really beginner at writing formulas I'm not well versed in AND/OR formulas. I tried looking it up, but my search came up empty.

    I want to create a formula that when a check box is clicked that it automatically changes the status.


    I have a Start check box and a Done Check box. When the Start checkbox isn't clicked I want the status to be "Not Started". When the Start check box is clicked I want the status to change to "In Progress". And finally when the Done checkbox is clicked I want the status to change to "Complete". What would the formula be?

    · Share on FacebookShare on Twitter

    Best Answer

    • Community Champion
      Answer ✓

      Hey @Caitlin Goodman

      If I understand you correctly, we'll only have to use Nested IFs for this formula vs also incorporating the AND/ORs.

      When thinking about Nested IFs, we first look for any conditions that, no matter what, will drive the outcome. This is because IF statements progress through the formulas until they reach the first True. The formula stops executing at that point. Therefore the sequencing of the IFs become important.

      =IF([Done checkbox]@row =1, "Complete", IF([Start checkbox]=1, "In Progress", "Not Started"))

      · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      Answer ✓

      Hey @Caitlin Goodman

      If I understand you correctly, we'll only have to use Nested IFs for this formula vs also incorporating the AND/ORs.

      When thinking about Nested IFs, we first look for any conditions that, no matter what, will drive the outcome. This is because IF statements progress through the formulas until they reach the first True. The formula stops executing at that point. Therefore the sequencing of the IFs become important.

      =IF([Done checkbox]@row =1, "Complete", IF([Start checkbox]=1, "In Progress", "Not Started"))

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    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