Box checks automatically if criteria is met - formula?

Options

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?

Tags:

Best Answer

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

    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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!