If(And) Formulas

Hi @Heather Farrell

I hope you're well and safe!

Try something like this. (You almost had it correct. it was only one to many parentheses)

=IF(AND([MGM Approval]@row = "MGM Approved", [HR Approval]@row = "HR Approved"), "Approved", "Denied")

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sorry about that!

I missed adding the part to set it as blank.

Try this.

=IF(OR([MGM Approval]@row = "", [HR Approval]@row = ""),"", IF(AND([MGM Approval]@row = "MGM Approved", [HR Approval]@row = "HR Approved"), "Approved", "Denied"))

Did that work?

All comments

Hi @Heather Farrell

I hope you're well and safe!

Try something like this. (You almost had it correct. it was only one to many parentheses)

=IF(AND([MGM Approval]@row = "MGM Approved", [HR Approval]@row = "HR Approved"), "Approved", "Denied")

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

@Andrée Starå that was it! Thank you!! I knew it was something simple like that :)

Easy to miss!

You're more than welcome!

@Andrée Starå If I wanted to add to the formula to leave that column blank if there is no data, would I be able to do so?

Try something like this.

=IF(OR([MGM Approval]@row = "", [HR Approval]@row = ""), IF(AND([MGM Approval]@row = "MGM Approved", [HR Approval]@row = "HR Approved"), "Approved", "Denied"))

Did it work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

@Andrée Starå That doesn't seem to work- it is returning a blank unless the cells are blank..? I did convert to a column formula to test. I also tried to put the IF(OR) formula after the IF(AND) to see if the order of operations would make a difference.

Sorry about that!

I missed adding the part to set it as blank.

Try this.

=IF(OR([MGM Approval]@row = "", [HR Approval]@row = ""),"", IF(AND([MGM Approval]@row = "MGM Approved", [HR Approval]@row = "HR Approved"), "Approved", "Denied"))

Did that work?

That worked! Thank you again!