Explore. Ask. Answer.

or Explore Discussions

Automating a push notification based on a cell value

Frank99Frank99 ✭
in Using Smartsheet
11/30/21
Answered - Pending Review

I have an automation process where I need to push a notification based on a specific time value within a cell.

So the data's coming in from a form with the date and the hour a phone call needs to be made. I.E 14:00.

When 14:00 rolls around I want to push a notification to someone listed in a contact cell.

Any ideas on how I can do this?

Answers

  • Genevieve P.Genevieve P. admin

    Hi @Frank99

    Smartsheet does not currently have Time functionality or columns in the sheet. However there is the ability to set Time and Date based automations on the hour. See: Create a Time-Based Automated Workflow

    Screen Shot 2021-12-01 at 6.30.51 PM.png

    You would need to create one Workflow per hour that could be selected.

    Screen Shot 2021-12-01 at 6.31.45 PM.png

    Let me know if this will work for you!

    Cheers,

    Genevieve

  • Frank99Frank99 ✭

    Hi Genevieve, thank you for the response, that will hopefully do the trick in this case.

Sign In or Register to comment.