UPDATE: I got “[Angle Goals].Sum(Priority)” to show values on the Angles database! Yay! Basically I’m trying to score things in many databases and then run those scores through a formula to then generate a list of “next priority” ideas (maybe in a Doc that can then get made into tasks). My problem …

[image] Mother_Bones: Are these ONLY for reports? Yes [image] Mother_Bones: Why can I not find a comprehensive list of functions for formulas when I’m looking for functions for formulas?? The formula field reference guide is here: https://the.fibery.io/@public/User_Guide/Guide/Formu…

[image] Chr1sG: . | Fibery .First and .Last and some other similar “sub” functions are not really well explained. And I’ve never found a use for the [This Entity] thing but it’s interesting. I’ve managed to get formulas to work both ways and since Absolute Value calculations can’t be done in…

HAHA! Ok so yeah every last formula is going to use info specifically from what is attached… oki doki… let’s see if I can add another hidden value…

[image] Mother_Bones: I’ve never found a use for the [This Entity] thing but it’s interesting. You might wanna read this .

[image] Mother_Bones: Absolute Value calculations can’t be done in formulas Do you mean Abs(x) ? It can be achieved using if(x<0,0-x,x)

:man_facepalming: That’s much better than Power(.5, Power(2)) like I was assuming I’d have to do…

Well, it took some time, but syntax was released today :slight_smile: [image] January 16, 2025 / microscope Very experimental My Items vs. All Items in sidebar, some emails and formulas improvements Changelog Today’s release is very modest, with just few update…

Building weighting formulas across databases and Lookup

Get Help

Chr1sG June 13, 2023, 10:13pm 5

You might wanna read this.

Topic		Replies	Views
Calculations within a Database with Formulas (Comparing Entities from the same Collection/Database) Get Help	11	276	April 29, 2025
Can't create lookup field from related object's formula field Get Help	10	303	April 29, 2025
Access databases in formula fields Ideas & Features	1	54	February 10, 2025
Formula fields that are filtered by the context they're viewed in Ideas & Features	7	135	September 5, 2025
Calculate lookups on the front end (based on filters) Ideas & Features	5	78	February 13, 2025

Building weighting formulas across databases and Lookup

Related topics