May 09, 2019 10:29 AM
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.
May 09, 2019 10:56 AM
This formula should work for what you wanted:
May 09, 2019 11:18 AM
Hi @Lauren_Thurman, @Yeshi_Wangchuk - I don’t think your formula quite works. There’s two scenarios where I think it needs a bit of tweaking:
I would propose a slightly different formula:
IF(FIND("Prioritized", C) > 0, IF(AND(A, B), "Ready" , "Not Ready" ), "Not Ready")
May 09, 2019 12:03 PM
:thumbs_up: :pray: Great! @JonathanBowen - I totally overlooked the other scenarios. I’m still learning, thanks a lot for the revision.