the ability of the count field type to factor more than one app | Voters

the ability of the count field type to factor more than one app

in progress

Yocheved Zelishovsky

currency its only possible select one app. to sum up from the Linked Record Field. id like to be able to sum up the matching criteria across different apps

November 20, 2022

Artem Kunytsia

marked this post as

in progress

Peter Novosel

Yocheved,
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:
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]

Yocheved Zelishovsky

Peter Novosel: thank you so much! I will try that later this evening. Do advanced formulas work with automation as well ?