Need help with if box unchecked in a column then denied is chosen in dropdown list

h_inda

Hello

Not very savvy when it comes to formulas, this time I am trying to have a " denied" automatically chosen in my dropdown list in my STATUS column when another column (MINIMUM REQUIREMENTS UNMET) is unchecked.

I started this but unsure how to finish it =IF([Minimum Requirement not met]@row = 0

Thank you for your help!

Hinda

Paul Newcome

All you need is to enter the desired output in the "value if true" portion of the IF statement.

=IF(logical_expression, value_if_true, [ value_if_false ])

https://help.smartsheet.com/function/if

h_inda

Please talk to me like I am a kid who doesn't understand this language. I have no idea what value if true is supposed to be. Copying and pasting what literally comes up when trying to enter a function is OBVIOUSLY not going to help. You did not read my question.

I tried this =IF([Minimum Requirement not met]@row = 0, [status]@row, "denied") obviously it's not working. I get a circular reference error

I have spent days and hours looking at ALL the smartsheet function pages and links and videos and I still don't understand it.

Paul Newcome

I did read your question. Your initial post indicated that you had started a formula but not finished it. OBVIOUSLY you didn't provide all of the information in your initial post.

Here is a link to the various error messages that can be encountered when working with formulas. This will explain the error you are receiving, some of the causes for that, as well as some suggestions for correction.

https://help.smartsheet.com/articles/2476176-formula-error-messages

h_inda