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

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

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.