Sign in to join the conversation:
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.
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
Hi Shaine,
I menat via row, not columns.
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.
When we duplicate a sheet via “Save as New…”, some automation are being modified or part of them are being deleted. For example:Original automation not he original sheet. The same automation, but on after saving the sheet with “Save as New…” This is one example of many. You can see that some of the options I selected…
Hi All, I need some help. I need a formula for sum of values within one column but I need to count it based on completion date. For context I want to messure how many labels were completed withing Q1, Q2, Q3 and Q4 2026. In my sheet is column with total amount of labels per change and another column has a date of…
Smartsheet is currently combining my automated emails from multiple lines into a single email. Is there a way to force each line to get its own email? I have column placeholders in the subject and body of the message, but it always combines lines into a single email when the automations are triggered at the same time for…
