ISBLANK

Mike B

Can I get help with this (repost)? 

=IF(ISBLANK(MBE@row, WBE@row, MWBE@row, DBE@row, ACDBE@row)," ", "Done")

Jeff Reisman

@Mike B

=IF(AND(ISBLANK(MBE@row), ISBLANK(WBE@row), ISBLANK(MWBE@row), ISBLANK(DBE@row), ISBLANK(ACDBE@row))," ", "Done")

In English, If all the fields are blank, leave this cell blank, otherwise, set this cell to "Done".

Mike B

Andrée Starå

Hi @Mike B

I hope you're well and safe!

Can you elaborate on how you'd like it to work?

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

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

Mike B

Hi Andree, I was trying to return a value if any one of the five cells were not blank.

Jeff Reisman

@Mike B

=IF(AND(ISBLANK(MBE@row), ISBLANK(WBE@row), ISBLANK(MWBE@row), ISBLANK(DBE@row), ISBLANK(ACDBE@row))," ", "Done")

In English, If all the fields are blank, leave this cell blank, otherwise, set this cell to "Done".

Mike B

Perfect. Thanks!!!!

Andrée Starå

@Mike B

I saw that Jeff had answered already!

Here's another option and the one I would use.

=IF(AND(MBE@row = "", WBE@row = "", MWBE@row = "", DBE@row = "", ACDBE@row = ""), " ", "Done")

Let me know if I can help with anything else!

Best,

Andrée

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!