Automating a push notification based on a cell value

Frank99
Frank99 ✭
in Smartsheet Basics

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. Employee 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

  • Frank99
    Frank99 ✭

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

Categories