IF + ISBLANK Formula

Barbara Silva

Hello,

I am not being able to apply this specific case of the formulas IF and ISBLANK combined. Can I have some help? I want the formula to return "Pending" in the verification status column if all yellow cells are blank, and "Verified" if at least one of the yellow cells is filled out. Thank you so much in advance!

Andrée Starå

Hi @Barbara Silva

I hope you're well and safe!

Try something like this.

=IF(COUNTIF([Exp Date 1]@row:[Exp Date 3]@row, <>"") > 0, "Verified", "Pending")

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 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!

Andrée Starå

Hi @Barbara Silva

I hope you're well and safe!

Try something like this.

=IF(COUNTIF([Exp Date 1]@row:[Exp Date 3]@row, <>"") > 0, "Verified", "Pending")

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 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!

Barbara Silva

I just realized I never responded. Thank you for your help, @Andrée Starå !!!

Andrée Starå

@Barbara Silva

No worries!

You're more than welcome!

✅Remember! 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!