If Formula Help

Platform discussions
,
1

I have hit a roadblock with this formula. It will only give me the results based on the first section.

If all in the first section are done then mark Time to Process. If instead all in the second part are done, mark Processed. and if nothing is done, mark Not Yet.

What did I miss?

image
image418×187 4.61 KB

2

Hi @heather.rankin,

The parenthesis after “A/P Emailed” shouldn’t be there. It should be put at the far end of the formula, ie. the formula should end with )).

Even with this fix, your formula is badly constructed.

Let’s call Condition1
AND({AUD Status}=“Pass”,{FAR Status}=“Pass”, {REG Status}=“Pass”,{BAR/ISC/TCP Status}=“Pass”, {Ethics Status}=“Done”).

And Condition2:
{Ethics Status}=“Done”,{Materials Reimbursement} =“A/P Emailed”,{Bonus Status}=“PR Emailed”

Your formula reads:

IF(Condition1,"Time to Process!", IF(AND(Condition1,Condition2),"Processed","Not Yet"))

With this syntax. you will never get “Processed” as a result, because if Condition1 is met, if will always return the first result, i.e. “Time to Process!”

You’d need to use:

IF(AND(Condition1,Condition2),"Processed",IF(Condition1,"Time to Process!","Not Yet"))

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

3

I really appreciate how you laid out the conditions so clearly. Heather, definitely take Gilles’ advice and adjust the formula as suggested. It seems like a small change in the structure could make a big difference in how the results come out.

4

Oh, yes I realize it was badly constructed and realized that ) was in the incorrect spot. Thank you so much for your help on this.