Alerts & Actions - Hours Remaining

jb@59069

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.

Jerry

Andrée Starå

Hi Jerry,

You can set this up with only one Alert I think.

I'll get back to you in a minute.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Hi Jerry,

Try this. (Please test it out because I didn't have time)

Would that work?

Best,

Andrée

 

 

Andrée Starå

Hi Jerry,

It was just a column name that I used because I couldn't see yours so you can change it to what yours is. 

Ok?

Best,

Andrée

Andrée Starå

Did you get it working how you wanted?

Sorry to hear you're frustrated with Smartsheet.

Best,

Andrée

 

Andrée Starå

Strange!

Could you share a screenshot of the columns and everything or even better share the sheet or a copy of it? Share too andree@getdone.se

Best,

Andrée

 

Andrée Starå

Hi Jerry,

How did it go? Did my solution work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Shaine Greenwood

Hi All—

If you find a great solution and you have the time, please share it in the community!