Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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!
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
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!
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
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.
Hi all, I am trying to build out a formula that will return "True" if the CIF #@row can be found above it in the same column (CIF #) AND the Days Since Created is between 30 - 365 days. All of the formulas I have tried have only gotten me so far as the "AND". Adding in the dates screws it up. The goal is to determine if…
I am getting a lot of REF errors for my predecessors and I can't figure out why. At first I thought I might have REF for predecessors to predecessors but that's not the case. When I export the file into Excel it shows the IDs in the place where it shows REF in SS. Each time I refresh the file I feel like different values…
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…
