Send daily alert to those who have not submitted

I need to monitor daily, those who have not submitted their temperature and type of their status daily before 10am of the day and inform them to submit their status through a form link.

How can I automate the daily alert to those who have not submitted their temperature for the day.

I used automate "Alert someone" base on the conditions:

Where "Name" "is not one of" name and where "Date" "is today"

But it don't work and send out alert regardless

of the condition above.

any best recommended methods?


Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 11/18/20

    Dear flashock,

    hope you are fine,

    1- did you check if you define the notification permission to unrestricted .

    2- did your user submit their temperature and type of their status using form. if so then use the following condition in the automation alert : when Temp is blank & date = today

    hope this will answer your question.


    Best Regards

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • flashock
    flashock ✭✭✭✭

    No, sorry, i only want to send to those who have not submitted for the day, not everyone in the dropdown name.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!