Create a flag if a project hasn't had an update in the previous week

[James_Costa]

Hi there!

I have a Table called Projects and another called Updates (both are connected via Linked Records), both are in the same Base. I’d like to have a flag (a binary 0/1 or true/false so I can put them in a Count Block on a Dashboard) for all Projects (that have a Status of In Progress) if they don’t have an Update for them for the previous week.

In the Updates Table I have the name of each record as the number of the week (calculated via a formula, with a little nuance for stragglers who might not update until Monday).

Any idea how’d I’d go about doing this?

Thanks in advance for your help!

James

[Aron · Accepted solution]

You can use the last modified time field and create a formula that checks whether it’s updated in X time.