I saw a post in the community at https://community.smartsheet.com/discussion/auto-refreshing-sheetsgrids which had a similar question. But no answer was provided and the last update (from another member) was in Dec. 2018. Again, no response or answer was provided.
I have a sheet, with formulas, to calculate today's date, and determine if today is within 7 days (or less) than the "due date" column. So each row has a due date. And I'm wanting to create alerts that would be emailed out, when the due dates are within 7 days or simply past due. But since the formula only runs when the sheet is accessed by someone, I'm concerned that the dates won't actually be updated and therefore the alerts won't go out as expected.
So I'm trying to figure out how the sheet can "auto-refresh" (as if someone accessed the sheet manually) so the formulas would run and update the TODAY date, etc.
My question is, how can I get the formulas (in a sheet) to run, even if no one actually accesses the sheet? I'm looking for a way to auto-refresh the sheet (as if someone accessed the sheet manually) so the TODAY formula would run (every day on its own).
Any advice or help would be appreciated.
Gary
