Help

Formula Help! IF AND + checkboxes

Topic Labels: Formulas
4498 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Lauren_Thurman
4 - Data Explorer
4 - Data Explorer

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!

3 Replies 3
Yeshi_Wangchuk
4 - Data Explorer
4 - Data Explorer

This formula should work for what you wanted:
IF(A=1,IF(B=1,IF(C=“Prioritized”,“Ready”,“Not Ready”)))

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:

  • Where one or more of the fields are empty (should show “not ready”)
  • Where the multi-select has multiple values selected (Prioritized AND something else then returns “not ready”)

I would propose a slightly different formula:

IF(FIND("Prioritized", C) > 0, IF(AND(A, B), "Ready" , "Not Ready" ), "Not Ready")

Screenshot 2019-05-09 at 19.16.07.png

JB

:thumbs_up: :pray: Great! @JonathanBowen - I totally overlooked the other scenarios. I’m still learning, thanks a lot for the revision.