How can I set a column to automatically select Yes or No based on other column criteria

gail.smith

If Submitted SC Form is Yes and Completed Training is Completed and SC Mailbox Status is Active than I need Completed All 3 Actions to select Yes, otherwise No if any of the three criteria are not met.

Jeff Reisman

@gail.smith Try this:

=IF(AND([Submitted SC Form]@row = "Yes", [Completed Training]@row = "Completed", [SC Mailbox Status]@row = "Active"), "Yes", "No")

Using AND like this allows you to enter multiple logical statements, separated by commas, which must ALL be true for the IF to select the true condition of "Yes". A common error with AND is that people forget the close off the AND statement with a parentheses before listing their true condition and false condition.

Alternatively, using OR in place of AND in the above formula would tell the IF that if ANY of the three logical statements is true, set the cell to "Yes".

Jeff Reisman

@gail.smith Try this:

=IF(AND([Submitted SC Form]@row = "Yes", [Completed Training]@row = "Completed", [SC Mailbox Status]@row = "Active"), "Yes", "No")

Using AND like this allows you to enter multiple logical statements, separated by commas, which must ALL be true for the IF to select the true condition of "Yes". A common error with AND is that people forget the close off the AND statement with a parentheses before listing their true condition and false condition.

Alternatively, using OR in place of AND in the above formula would tell the IF that if ANY of the three logical statements is true, set the cell to "Yes".

gail.smith

Thank you so much @Jeff Reisman :)