nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

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.

Welcome!

Auto Change Color or send a reminder / Notification

richard_uy

Hi, As per attached screenshot, The stock level is 3000, When the week 12 / 13 / 14 below the 3000, can the stock level cell auto change color or send a reminder via mail?

Thanks in advance.

Screen Shot 2018-03-20 at 1.36.55 PM.png

Find more posts tagged with

Comments

Shaine Greenwood

Hi Richard,

You can create a conditional formatting rule that will change the cell or row color when those columns fall under that amount. More on conditional formatting here: https://help.smartsheet.com/articles/516359-conditional-formatting

You can also create a notification rule that will send an email when those columns falls below 3000. Details on creating notification rules are available here: https://help.smartsheet.com/articles/542904-using-notifications

richard_uy

Hi Shaine,

I menat via row, not columns.

Mike Wilday

Shaine's methods will work with the row... but its checking the particular column, for the total amount to drop below your settings, then it will send you the row. A notification will send you an email and conditional formatting will color the row.

Sign in to join the conversation!

Quick Links

Trending discussions

Automation Issues - Values from Curly Brackets Not Appearing Correctly
Is anyone else experiencing this issue today (7/28/2026)? Every time an automated email triggers on its own today, whether it's a regular alert, update request, etc, the values that usually appear when the automation workflow includes a field in curly brackets (ex: {{First Name}}) appears as a weird alphanumeric value in…
Problems with placeholder fields?
Hi - Is anyone else having problems with placeholder fields in update request automations today? I've been notified by my staff that our automations today are showing random text strings instead of the field data that they are supposed to. For example, in one of my sheets, there's an automations thatis supposed to show a…
Sudden malfunctioning in notifications
Hello to all the community, my team is experiencing an issue with the notifications in Smartsheet. In the last hour the notifications started including only the placeholders of the columns, instead of the content of the related cell. I checked with the support and this could be related to changes in the workflow or in the…