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.
I submitted a ticket, but thought I would ask here. I am having an issue with sheets that I own (our org is on a Business plan). For the last two years, we have been using the sheets without an issue - our admin and many Editors (all shown as Guest since they are outside of our organization) were able to edit the sheets…
Hello! I’ve noticed for a LONG time that when I change the name of a column in a source sheet, the corresponding column in reports breaks, which then causes dashboard widget charts (that rely on those reports) to fail. Is there a way to: Prevent this issue when renaming columns? Fix existing reports and dashboards without…
Dear All, my account was suspended for a long period in which my sheets were deleted. I renewed my account and asked technical support if my sheets could be recovered. I received this message below, but I do not seem to get a reply back afterwards and still do not have my sheets recovered. Thanks for…
