Alerts & Actions - Hours Remaining

jb@59069 ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hello all.

We track time for our clients and need to alert certain team members when the "Hours Remaining" reaches certain thresholds.

At this point, I have created some Conditional Formatting that changes certain cells colors, but we really need to have team members receive an alert email at several ranges.

So far, I cannot figure out how to create an alert given the selections available.

Could someone help with this, please? I have attached a screen shot of a portion of a time tracker. Hours Reaming needs to be the trigger with various points triggering emails being sent. I.e., if Hours Remaining is 20, an alert with a message stating that 20 hours left, if 10 then another email, etc.

Thank you.