If one column cell is less than a different column cell, return "ALERT"

Travis Griffin

Been poking at this for hours. I have 2 columns:

QTY & Thresh Q

I want another column [Quantity Alert] to return "ALERT" if QTY is less than or equal to Thresh Q

Andrée Starå

Hi @Travis Griffin

Try something like this.

=IF(QTY@row = ""; ""; IF(QTY@row <= [Thresh Q]@row; "ALERT"))

The same version but with the below changes for convenience.

=IF(QTY@row = "", "", IF(QTY@row <= [Thresh Q]@row, "ALERT"))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

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

Andrée Starå

Hi @Travis Griffin

Try something like this.

=IF(QTY@row = ""; ""; IF(QTY@row <= [Thresh Q]@row; "ALERT"))

The same version but with the below changes for convenience.

=IF(QTY@row = "", "", IF(QTY@row <= [Thresh Q]@row, "ALERT"))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

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

Travis Griffin

Wow. I never would have come up with that. And not afraid to admit that I don't quite understand why. But THANK YOU!

Andrée Starå

@Travis Griffin

It's easy when you know, and now you do too!

You're more than welcome!