Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Formulas
Solved
Jump to Solution
540 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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

See Solution in Thread

1 Reply 1

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