Number of NetDays since last event

Andrée Starå

Yes, you'd link from the "Master Sheet" to all others that need to be "updated" daily. Of course, it doesn't need to be automatic with Today(), so you could also manually trigger the "update".

Best,

Andrée

Paul Newcome

I wonder... Would sending as an attachment daily also work as a trigger? I have some sheets that need the TODAY() updated daily, but other than that, I don't have any sheet that I open daily. I'd love to be able to avoid being REQUIRED to open something every day.

Andrée Starå

If I remember correctly, it won't unfortunately because I think it looks at the state of the sheet as is and the attachment isn't triggering a change. I also have a recollection of there being an issue with conditional formatting not showing on a report because the sheet wasn't "opened/updated".

But maybe it works today. Try it I dare you!