Status update to Full depending on drop down list selection


Hi There,

I'm attempting a formula based on the responses of certain calls that come in or calls we make. There are 4 columns total where we are either calling out to somebody and trying to track response, or they are calling back in and we complete the employee. When we call out, we have to call out every 2 days up to 3 attempts. If they answer and we are successful, we mark "Enrollment Complete" and don't need to make any other calls. If they return the call, under Inbound Call Result, we could also mark "Enrollment Complete". My issue is, when I attempt the formula several different ways, it won't recognize that when any of these 4 columns say "Enrollment Complete" the status bar should be "Full". That lets us know we don't need to be calling out, and that they have called back in. How can I get the status bar to update to "Full" automatically when that option is selected? If there is nothing there, it should be "Empty" according to the status bar.

I have tried using an IF(AND statement, and when I add each column to it, it generates the error. This was me trying to group it with another row.

=IF(AND([Inbound Call Result:]@row="Enrollment Complete", IF(AND([1st OBC Result]@row = "Enrollment Complete"), "Full", "Empty")))

Here are the names of my columns for tracking the calls:

Here is the wording for the status bar that I have included in the formula:


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!