My Idea is for you to create the posibility for the user to be able, when he is creating a formula column, to create a DIFFERENT formula on each cell/row. Exactly like in EXCEL. this way we will be able to use and link multiple colums and results.
if its to difficult to do it, then create the posibility for the user to be able to CREATE a different formula for each GROUP. Basically this could be a possible workaround in many situations. This workaround can help many of us to deal with calculations.
If one of those option can be possible, this will make a lot of people happy.
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
3
HI Edward,
This is something that can be easily achieved with the Advanced Formula Booster. This 3rd-party app is unique in many ways. It does NOT use the formula column but rather casts its results to regular columns.
Its syntax editor can accomodate up to 100 lines (ie. 100 instructions). So you could easily check a value of the item (the group for instance) and use SKIP/RESUME to run calculations based on the group name. Here is an example:
In my example, line 1 checks if the item is in Group “NYC”. If it isn’t, it skips the following lines until it finds the RESUME instruction. If it is, it assigns a user to the item then it stops the formula.
Then on line 5, it checks if the item is in the Chicago group and skips the following lines if not. If in Chicago, it assigns another user and changes the Status column (you can change multiple columns within 1 formula).
This is a way to create 1 formula (=1 automation) that kind of run different sub-formulas for each item (based on a criteria).
You can use a simple if statement in the formula and a status column to achieve your use case. Then you can setup an automation that will change the status when an item is moved to a group respectively. so depending on the status a different formula is issued in the row.
if its to difficult to do it, then create the posibility for the user to be able to CREATE a different formula for each GROUP. Basically this could be a possible workaround in many situations. This workaround can help many of us to deal with calculations.