Stock sheet automatic email when stock drops below an amount....

Hi everyone,

We're putting together a stock sheet and we want to create notifications so that when a figure in a cell drops below a certain amount an email is automatically sent to the relevant people so they know to re-order.

Can anyone help please?

Many thanks!

Find more posts tagged with

Formulas

Solution Center

Email Notifications

Comments

Dave Godfrey

Hi,

This can be do by setting a new Notification in the Alerts and Actions

you will need to specify the column that you and select is less than / less than and equal to. This will then send a notification to the contacts that select. I have added a screenshot so you can see how it is done.

Dave

MCS

Thanks for your help Dave, one question....

This seems to apply a rule for the whole column, can you set it so that it applies rules to individual cells.

For example in the 'quantity in stock' column I might want an automated email to be sent when cell G5 (brochures) is equal to or less than 20, however in cell G6 (user guides) I might want an email sent when it's equal to or less than 40.

Cheers!

Dave Godfrey

Hi,

The notifications are specific to the columns and are generated when the conditions in a row are met.

You can create more than 1 notification and add more conditions

Where Item equals brochure and quantity is equal to or less than 20

Where Item equals user guides and quantity is equal to or less than 40

Hope this helps

Dave

12vanblart

Instead of configuring a new notification for each row, you can create 2 extra columns, `Stock Warning` and `Warning`.

The Stock Warning column will be a number field where you set the quantity at which you would like to send the notification.

The Warning column will be a standard text field. This should be set to

=IF([Stock Warning]1 >= Qty1, "True", "False").

Then your notification can be setup as seen in the screenshot.

Sign in to join the conversation!

Quick Links

Trending discussions

Logging separate data points of the same type of data for one row
Looking for a way to easily log and reference multiple data points for the same type of data (ex: successful phone contacts) that all show for one entry (by member name). Want this to be both easy to enter the information (ideally by interacting with the same row via Dynamic View), and easy to see data on the back end of…
Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
Why does the parent task my % column show as a decimal value instead of a percentage?
Why does the parent task my % column show as a decimal value instead of a percentage? I checked the column and project settings, and they are identical to another smartsheet in which the values show up as a percentage.