Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

List linked records not linked

Topic Labels: Formulas
Solved
Jump to Solution
343 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Sareyh
5 - Automation Enthusiast
5 - Automation Enthusiast

I have created an airtable base to see what steps different organizations need to take. I have a list of all of the steps in one table. And a list of all organizations in another. I have a linked column connecting the two to show what steps each organization has taken. I am trying to make it so I can easily see the steps that an individual organization has NOT taken yet/ what they still need to do (They all have to do all of the steps). I don't necessarily care how it is done as long as I don't have to do it manually and can easily see what steps have not been taken by each organization.

For example, I want Organization 2 to say that it still needs to do steps 15, 19, and 20 (the steps do not have to be done in order for the most part).

Images and an example base are attached for a better understanding of what I am trying to get at. Link: https://airtable.com/appP3aMz3aJ2jYLGp/shrnb4rpltjlBPdZH/tblbT6mtF29tzfsbF/viwiytG0caCqn0XZT?blocks=...

Thank you for any help that you can provide!!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

If the steps are static and don't change, you could do this with a formula:

Screenshot 2025-02-10 at 10.50.54 AM.png

Screenshot 2025-02-10 at 10.50.51 AM.png

If they're dynamic, then I'd recommend a table where each record represented a single step linked to a single org, and then you could do lookups based on whether the step's completed or not:

Screenshot 2025-02-10 at 10.53.23 AM.png

Screenshot 2025-02-10 at 10.54.14 AM.png

And I've set it up for you here!

See Solution in Thread

5 Replies 5
TheTimeSavingCo
18 - Pluto
18 - Pluto

If the steps are static and don't change, you could do this with a formula:

Screenshot 2025-02-10 at 10.50.54 AM.png

Screenshot 2025-02-10 at 10.50.51 AM.png

If they're dynamic, then I'd recommend a table where each record represented a single step linked to a single org, and then you could do lookups based on whether the step's completed or not:

Screenshot 2025-02-10 at 10.53.23 AM.png

Screenshot 2025-02-10 at 10.54.14 AM.png

And I've set it up for you here!

Sareyh
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi adam,

Mostly, they are stagnant overall, some may not apply to some of the organizations, but I was just planning on marking those as complete. For the static formula, the only thing is that the tasks have long names, not numbers, and I currently have 47 tasks on the list. And I don't want them to be referred to as numbers cause that is how I will refer to them. So is there a way to do that easily with a formula? I'm thinking that it might be best to do it the other way with the Org<>Steps table.

Thanks!

VikasVimal
6 - Interface Innovator
6 - Interface Innovator

You'll need two linked record fields. One for tasks assigned, and one for tasks completed. An automation or script can highlight the tasks that are incomplete of those assigned.
You can use an automation to auto assign tasks from a view. Then, as tasks are completed, add them to the Completed tasks linked record field. An automation would handle the unfinished tasks out of tasks assigned.

Alternatively, Have a third mapping table of tasks assigned per org. each task assigned to each org will be one record here. You can then rollup finished and unfinished tasks easily. From a db perspective, this is a more solid approach.

Yeap, formula wise it'd be the same, it'd just be a pretty long formula

Having the Org <> Steps table would be nice yeah, and it would let you track specific data tied to each task too

Sareyh
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a way to set this up that reduces the number of records I need? With 4 orgs (plus other things I need in that base) I am already over the limit (I am on the free plan). Thank you!