Box checks automatically if criteria is met - formula?

nicole.turner

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?

Amanda Alv

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!

Amanda Alv

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!

nicole.turner

@Amanda Alv perfect! I was missing the 1, 0!

Amanda Alv

Awesome- so glad it worked for you! Have a great day!