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!