Hello everyone,
I'm looking to build a formula against multiple columns in my database. It's not that easy to understand, I'll explain my goal with an example:
Gray part:
Here, here are 4 different object types (ENT1,..,ENT4). Each of the objects is associated with a progress number (column T), these numbers are linked to well-defined operations.
Yellow part:
These cells show which "numbers" will undergo each object, and associates this number with operations. When the cells are empty, it means that the object will not undergo this operation.
The objective is :
- Sum the durations, knowing that the object has had an advancement (Ex: the object ENT2 is located at number 1749, so what it did before in 1500 does not interest us)
- Let's take the object ENT2, it would be necessary to make the sum of the duration 2100 and the duration 2500 because these are the numbers that this object must undergo.
Thanks for your help,
Cordially
