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
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?