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

Hi,

 

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

4.staus

 

Please suggest.

 

Jayam Nagesh

Comments

  • ruiovaz
    ruiovaz ✭✭
    edited 03/17/17

    Hi

    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.

     

    Rui

This discussion has been closed.