Forum Discussion

Qrew Trainee

3 years ago

Calculating multiple fields' data based on checking another field's value matching a source field

So I am trying to match up and check work/allocations by checking Grower/Supplier Tag Details against the "Product ID" section above. Currently running into a large formula problem and wondering if th...

Formulas and functions

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

Is this what you mean

- (IF(=, , 0)
- (IF(=, , 0)
- (IF(=, , 0)
- (IF(=, , 0)

//on T1, the goal is to test F, G,H,I to see if they equal A. Any that do should have their //corresponding values J,K,L, or M added up and subtracted against N

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

DavisWard
Qrew Trainee
3 years ago
I think so, let me build out that formula and see if I'm getting the results I'm expecting.

------------------------------
Davis Ward
------------------------------
- DavisWard
  Qrew Trainee
  3 years ago
  Yes, that is it. Thanks for that. I should have thought of that before, but it works perfectly.
  
  ------------------------------
  Davis Ward
  ------------------------------