Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

I would like to send daily reminders of a row to the employee of that particular row till the status

Jayam Nagesh1
edited 12/09/19 in Archived 2017 Posts



I want to send daily remainders of a row to the employee of that perticular row till the status colomn shows finished. The colomn names in my sheet are :


1, start date : system generated date and time( this is not visible in the reminder)

2.end date : we can utilize this based on the status colomn

3.emplyoee-1, employee-2 & Manager



Please suggest.


Jayam Nagesh


  • ruiovaz
    ruiovaz ✭✭
    edited 03/17/17


    I think you have to insert a new column (Ex: "Reminter date) with a formula something like this:


    =IF(AND([status]n<>1,TODAY(), "")


    assuming "status" would be the percent completed column (%).

    Then insert a Reminder pointing to the "Reminder date" (date) column and "Employee" (contact) column.


    Hope this helps.



This discussion has been closed.