Changing status column based on more than one status column

Feature requests
, ,
1

Our team has a shared board where different People have their own Status column and update it according to their work.

Once we have 2-3 Approved status’ we then require a manual review of the Overall Status column. I would like to automate the change in the Overall Status based on Approvals in others and then notify those team members (people columns) that such a change was made.

Is this feasible? I’ve tried automations and formulas and just haven’t figured it out.

2

Hi JC,

Can you share a screenshot of your setup? People are… items, sub-items? Where is the Overall Status column in that board?

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

3

Hi Gilles,

Thanks for chiming in sir.

Here’s the set of people columns

QA board people columns
QA board people columns1181×205 22.4 KB

Where In Charge, Buyer, and EHS all correlate to the status columns below for Supply Chain, QA, and EHS. The Vendor Status column is the one I’d like to automate once the other three are all “Approved”. And alternatively I would like to be able to automate other outcomes e.g. Rejected, in a similar manner.

QA board status 2
QA board status 21081×218 20.9 KB

Thoughts on how to achieve that?

Thanks

J.C.

4

I am still not too clear on the relationship between the people columns and the status columns and if you want to automate this relationship. But if you want to automate the vendor status based on the other 3 statuses, this is relatively easy.

You should be able to achieve it with 3 automations like this one:

2024-03-06_09-31-41

You’d also need to set up When Status 2 changes…, When Status 3 changes…

Is this what you were looking for?

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.