Automated emails based on cell values

Ty Werven

I am trying to decide what the best way to set up an automated weekly email would be based on the image below.

Basically, I want to send something out weekly based on the column items that are not meeting a certain set par level. For example the weekly list should include all items with '0' and exclude items that greater than 0. Is this possible to fully automate and include a row items that are 0 but leave out anything that is greater than 1 weekly?

Realistically, even if I could include something like below as a image in an automated email it would get the point across.

jmyzk_cloudsmart_jp

Hi @Ty Werven

Here is my solution.

First, I added helper checkbox columns, [Either Zero] and [Both Zero], with the following formula.

https://app.smartsheet.com/b/publish?EQBCT=d652693d7b0d404fbe872894e987418c

[Either Zero] =[Last 7 Days]@row * [Last 14 Days]@row = 0

[Both Zero] =[Last 7 Days]@row + [Last 14 Days]@row = 0

Second, I created Automation Workflows using them as conditions, triggered by time.

You can use an update request or alert someone.

Here is what I got.