Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Task Status Formula based on Sub-Task Completion

Topic Labels: Formulas
Jump to Solution
879 8
Showing results for 
Search instead for 
Did you mean: 

I’ve built a formula that shows a Status in my Task field based on how many Sub-Tasks are complete:

IF({Sub-Tasks Complete} = 0, “ :radio_button: Not Yet Started”, IF({Sub-Tasks Complete} = {# of Sub-Tasks}, “ :white_check_mark: Complete”, “ :orange_circle: Working On It”))

For some of my Tasks there is only one Sub-Task. When one of my teammates moves the Sub-Task into the “Working On It” status, I would like the status in the Task field to say, “Working On It.” Not sure how to change my formula to do that. Any suggestions?



1 Solution

Accepted Solutions

UPDATE - I put another space between the “IF(” and the “AND” and now the formula works…so thanks Jeremy!!

See Solution in Thread

8 Replies 8

I think this is a case where a picture of your table, and the relevant fields, would probably help. Just to see what types of fields you are referring to. I’m assuming rollups for some of these, but not sure.


So the first image, shows the fields I use to calculate the status. The second image is how I’d like it to appear to my client. When there is only 1 sub-task for a Task, it reads as “Not Yet Started”

My team uses Kanban to change status from Not Yet Started to Working on It. We use a single select for this. image

Hi @K3ssen

I think you’re going to need another Rollup field, in addition to your {Sub-Tasks Complete} field. You’ll need one for {Sub-Tasks in Progress} that Rolls up Sub-Tasks where Status = "Working On It".

Then you can adjust your Task Status formula like so:

   AND({Sub-Tasks Complete} = 0, {Sub-Tasks in Progress} = 0), 
   “🔘Not Yet Started”, 
      {Sub-Tasks Complete} = {# of Sub-Tasks}, 
      “🟠Working On It”

Jeremy - thanks for the formula. I added the roll-up field you suggested and the formula is showing as invalid. image

Here’s my roll up field: image
Am I missing something? Is that Aggregation formula correct? thanks again for your help on this!


UPDATE - I put another space between the “IF(” and the “AND” and now the formula works…so thanks Jeremy!!