Skip to main content
Solved

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

  • April 21, 2020
  • 1 reply
  • 27 views
J

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

Best answer by Aron11

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

1 reply

A
Forum|alt.badge.img+3
  • Aron11
  • Inspiring
  • Answer
  • April 21, 2020

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

A
Terms & ConditionsAccessibility statement