Skip to main content

Hi All,

I’m relatively new to Airtable and I’m struggling to figure out how to structure the formula to do what I want. I know roughly how to do it in Excel, but really struggling to translate how it’d work in Excel to Airtable. There are multiple things I need the one formula to do, any help on how to structure one or more parts of the formula would be appreciated.

  1. Formula is in my “Modules” tab, but looking up data in my “Tasks” tab
  2. “Module name” field in both tabs is linked with a “Link records” type of field in the Tasks tab
  3. Each Module has multiple tasks (they’re sequential, with no more than 1 “In Progress” at a time) and I’m wanting the Modules tab to have a field that displays what Task is currently “In Progress”
  4. I also want it to state “Not started” if all the Tasks associated with that Module are “Not Started” or “Complete” if they’re all set to “Complete”

The structures I’ve tried that are similar to Excel keep saying that the formula has issues and can’t be saved so I’m getting frustrated. Especially because I don’t know what to look for to find the answer if it’s already been provided. The classic, I don’t know what I don’t know problem.

Thank you in advance for any help you can provide.

Does this look right?

If so, I’ve set it up here for you to check out

 

For the task display, we’re using a lookup field with a conditional:

And for the overall status, we’re using a rollup field with a formula:

 
IF(ARRAYUNIQUE(values) = 'Done', 'Completed') &
IF(ARRAYUNIQUE(values) = 'Todo', 'Not Started')

 

This is exactly what I needed! Thank you!

Reply


Terms & Conditions