Hi all,

Looking for some assistance with a formula I’m working on.

Columns A and B are checkboxes and Column C is a multiple select field with one of the options to select being “Prioritized”.

How would I write out a formula for "if A and B are checked AND Column C = “Prioritized” return = “Ready”

If anything else (neither are checked, only one is checked, or the project is not prioritized) then return “Not Ready”.

Does that make sense? I think I’m struggling with the “AND” portion since this isn’t excel.

Help!