the ability of the count field type to factor more than one app
marked this post as
If I'm understanding your scenario correctly, you can use a Formula field to do what you want. Here is an example with two SUMIF statements that are combined with a SUM:
SUMIF( [Link to App 2].[Status] == "Complete", [Link to App 2].[Number]),
SUMIF( [Link to App 3].[Status] == "Complete", [Link to App 3].[Number])
Just replace the field names to match the ones in your App and you would be all set.
You could always replace the SUMIFs with SUMs if you don't need the conditional capability - e.g. SUM([Link to App 2].[Number]
Peter Novosel: thank you so much! I will try that later this evening. Do advanced formulas work with automation as well ?