networkday trigger for update request -- requires opening sheet?

I have a number of update requests that I've set up to "trigger" from a column that calculates the number of networkdays left before a due date. For example, I want a manager to update the page count of a report 3 days before that report goes out to an editor so that we know if the length has increased.

But, if that particular day happens to be a Monday and I have that day off and don't happen to open my sheet on that Monday, then I've missed the window and when I open the sheet on Tuesday that column will go directly from 4 to 2, thereby never triggering my update request.

Anyone have a workaround for this so that triggers will work even when/if the main sheet isn't opened each day?

Find more posts tagged with

Government

Project Management

Update Requests

Comments

Shaine Greenwood

Hello,

For formulas to calculate and update to the latest value, the sheet does have to be opened and then saved. Formulas won't calculate on the backend and save the sheet without somehow being opened first.

As a workaround: you might try third-party integrations to do this for them, such as Zapier or Azuqua to see if they can open the sheet for you.

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard % are not matching
Hi! I have a Dashboard feeding off pretty simple raw data. It's mainly detailing this is how many accounts we think we'll get, this is how many we've gotten and then provides a %. I wanted to add a chart just to pretty it up a bit but now the % done is reporting differently and I have no clue why. Here is the raw data: The…
Notifications Currently Experiencing Issues?
Hi All, I seem to be having a bunch of notification issues, and I'm wondering if anyone else is experiencing issues. Please keep in mind I have had these automations in place for over 2 years already & they always worked as expected. Is this a system-wide issue, or should I connect with Smartsheet Support? Issue 1 -…
New user; How to sort and format data by date
Hi! New user here. We have a basic sheet to track dates, hotel reservations, and the project. How can I format all dates to be uniform? My goal is to be able to sort by date or amount. Currently, we may have one date entry as 08/25/25 and another as 1/12/25. This really affects sorting.