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.
I would propose a slightly different formula:
IF(FIND("Prioritized", C) > 0, IF(AND(A, B), "Ready" , "Not Ready" ), "Not Ready")