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.
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
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.
Hi. Does saving a sheet after hiding columns delete the hidden columns or will they still be there?
Can someone help me please? In the “Queue” column, I have “mapped” from “ComponentID” column a list of values (using IF function), but now I must add to the existent formula the new value “ArtStation.” This comes from a long list of alphanumeric codes. All those codes start with “asset”, the problem is that I get…
Hello - is it possible to use a group already established in SmartSheet to fill/populate a drop list for a data point? Example - we have a SS group created for 40 project managers, I would like to type the name of the group in the drop down and the 40 names populate in the drop down list without having to type all 40 names…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.