I need to create a calculation field in APP A to sum all data from FIELD B1 from APP B (in a different workspace). That sum must be done with a condition (like sumif function from excel). Here is the condition: all items created in APP B of which category value FIELD B2 in APP B match the same category value FIELD A2 in APP A , should be added up for the FIELD B1 in APP B. And the result must appear in that calculation field in APP A.
Thanks for your help.
Please sign in to leave a comment.