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?
Comments
-
Hello,
This one is tricky, as your hunch is correct—formulas won't calculate and trigger rules until the sheet is opened and saved. This is more noticeable with the TODAY() function, as it'll only reflect the current date in your sheet when the sheet is opened and saved.
You're on the right track with the =IF([Start Date]1 = TODAY(), "Yes") function and then basing an update request rule off of that, but you'll need to open and save the sheet once a day.
-
This is how I force select sheets to refresh:
http://ronin-global.com/2017/03/15/forcing-today-refresh-in-smartsheet/
I don't need this functionality often.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
