Alert based values in two columns

Jackie Callahan

Hi,

I have a total inventory column and a reorder point column. I'm trying to make my sheet alert someone when the inventory falls below the reorder point. I can't seem to figure out how. I know I'll need a helper column. I thought I'd do a check box and then have the alert set to when the checkbox is checked. But I can't figure out how to make the check box check!

I don't care how it's done, it's fine if there's an easier way to do it. But if anyone could help me figure out how to notify someone when a figure in one column falls below a figure in another column, I sure would appreciate it.

Thank you!

Andrée Starå

@Jackie Callahan

Excellent!

You're more than welcome!

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

Try something like this. Replace the column names so they match yours.

=IF(Current@row = ""; 0; IF(Current@row <= Reorder@row; 1))

The same version but with the below changes for convenience.

=IF(Current@row = "", 0, IF(Current@row <= Reorder@row, 1))

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!

Jackie Callahan

https://community.smartsheet.com/discussion/comment/253387#Comment_253387

Hi Andrée,

Thank you so much for your help! Unfortunately, I am still getting #unparseable. Below I've pasted the formula. The inventory column is title Total Inventory at PF and the reorder column is titled Reorder Point.

Can you see something I've done wrong? I'm in the U.S. but I tried it with the semi colon too.

=IF(Total Inventory at PF@row = "", 0, IF(Total inventory at PF@row <= Reorder Point@row 1))

Really appreciate your help, thank you!

Jackie

Andrée Starå

Happy to help!

Try this. You'll need to use Square Brackets when there is more than one word, numbers or special characters in the column name.

=IF([Total Inventory at PF]@row = "", 0, IF([Total Inventory at PF]@row <= [Reorder Point]@row, 1))

Did that work?

Jackie Callahan

https://community.smartsheet.com/discussion/comment/253561#Comment_253561

YES! Oh thank you so much!!! I'm new to smartsheet and hitting the ground running so these little things trip me up sometimes. Thank you thank you!

Andrée Starå

@Jackie Callahan

Excellent!

You're more than welcome!

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