Box checks automatically if criteria is met - formula?


Hi! I'm trying to get a ticket issue checked as 'resolved' when somebody fills out a certain field. How do I get smartsheets to automatically check 'resolved' when "self help recommendation" column is "I have tried this and found a solution". Any help?


Best Answer

  • Amanda Alv
    Amanda Alv ✭✭✭✭✭
    Answer ✓

    Hi there,

    The following formula should do it for you:

    =IF([Self Help Recommendation]@row = "I have tried this and found a solution", 1, 0)

    Let me know if you have any questions!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!