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.

Logical Update Request

JeremiahHorstick ✭✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

I am thinking about a scenario with an automatic update request:

On the task start date, send an update request to the 'assigned to' column.

On task completion , send an update request to the 'assigned to' column.

Looking at the new update request functionality I am wondering if anyone has thought of a way to do this.

Maybe i can add a column with a formula (if start date = today, yes,,) and have that column trigger the update request, sent to the contact in the 'assigned to' column.

Will the formula calculate & execute while the sheet is not open?




This discussion has been closed.