β Here is the full formulas reference
What is inside the Article (overview list)
Collections (summinmaxavgcount)
Sum:
Spent Effort on the Project Level
Sprint Capacity on the Sprint Level
Total Revenue on the Project Level
Billable Total using Time Tracking App
Total Expenses on the Project LevelCount:
Number of tasks for the project
Number of stories for the sprint
Anything you wantGet Average:
OKR progress
Delivery cost
Goods price
Effort per taskFind maximum:
The highest price
The most complicated task (by effort)
The task, that was planned to finish lastFind the minimum:
The lowest price
The easiest task (by effort)
The task, that was planned to start first
Filter inside collections (filter data for summinmaxavgcount)
Spent Effort on the Project Level for Tasks, that are in "Done" State
Progress on the Project Level, based on the total amount of Tasks and finished one **(pro level)
Remaining Effort on the Project Level for Tasks, that are still not done yet **(pro level)
Total Revenue on the Project Level from Invoices, that are Paid already
Spent Effort on the Project Level for Tasks, that has Planned Start before Today
Dates Operations
 calculate planned duration in days
 calculate actual duration in days
 calculate how many days are left before the start
 calculate how many days are left before the deadline
 calculate planned duration in hours/minutes/seconds
 calculate actual duration in hours/minutes/seconds
 create a field that will show date N days before the deadline (Deadline  N days)
 create a field, that will show a Review date (Actual end + 7 days)
Logic (If, and, or)
 mark urgent tasks based on deadline coming
 check whether your employee has too many tasks
 cycle time
Cases
Collections (summinmaxavgcount)
Difficulty level: β
π‘When it can be helpful? :
Calculate (Sum):  Databases  Field to sum  Formula syntax 
Spent Effort on the Project Level  Project β‘ Task  Effort 

Sprint Capacity on the Sprint Level  Sprint β‘ Story  Effort 

Total Revenue on the Project Level  Project β‘ Invoice  Invoice Value 

Billable Total using Time Tracking App  Project β‘ Time Log  Hours 

Total Expenses on the Project Level  Project β‘ Expenses  Spent 

ο»Ώ
Now, let's take the first row as an example and create these Formulas stepbystep πͺ:
We will calculate spent Effort on the Project Level ( Project β‘ Task )
Schema:
Data:
Formula text ( Formula field must be created on the Project level):
Tasks.Sum(Effort)
Formula explanation:
Notes:
If you have an existing formula (like the one used above), and then change a field name, Fibery will automatically update your formula to reflect the new field name.
Please, check that your Child Database has a field, you are going to work with π§
Similar Formula syntax works for these Aggregation Numerical calculations:
οΏΌ
Function  Formula syntax 
Avg


Count


Max


Min Returns the min of a series of numbers  check the lowest price 

Filter inside collections (filter data for summinmaxavgcount)
Difficulty level: ββ
π‘When it can be helpful? :
Calculate (Filter(Conditions).Sum):  Filter Condition  Formula syntax 
Spent Effort on the Project Level for Tasks, that are in "Done" State Databases: Project β‘ Task  State.Name = "Done" Field to sum: 

Progress on the Project Level, based on the total amount of Tasks and finished one **(pro level) Databases: Project β‘ Task  State.Final = true Field to sum: 

Remaining Effort on the Project Level for Tasks, that is still not done yet Databases: Project β‘ Task  State.Final != true Field to sum: 

Total Revenue on the Project Level from Invoices, that are Paid already Databases: Project β‘ Invoice  State.Name = "Paid" Field to sum: 

Spent Effort on the Project Level for Tasks, that has Planned Start before Today Databases: Project β‘ Task  Planned.Start < Today() Field to sum: 

Now, let's take the first row as an example and create these Formulas stepbystep πͺ:
We will calculate spent Effort on the Project Level, but for those Tasks, that are done already ( Project β‘ Task )
Schema (from our Project Management Template):
Data:
Formula text ( Formula field must be created on the Project level):
Tasks.Filter(State.Name = "Done").Sum(Effort)
Formula explanation:
Notes:
If you have an existing formula (like the one used above), and then change a field name, Fibery will automatically update your formula to reflect the new field name.
Please, check that your Child Database has a field, you are going to work with π§
On this formula, we are writing "Done" in quotes  by quotation marks we denote Names. So, if your field, you are going to filter is called is "Amazing", then the formula will look like
Tasks.Filter(State.Name = "Amazing").Sum(Effort)
Instead of summarizing fields in the end you can use any other formula (count, min, max, avg. and etc.)
Pro users tips πͺ:
In the Table, you could see this formula

What does State.Final
mean?
Well, you can open any State from the Workflow Extension Field, and mark it as a Final one.
And:
 !=
 is not
 =
is
Dates Operations
Difficulty level: β
Function  Formula syntax 
Todays Convert a time duration into a number of days. 

Today Date function which returns the current date. 

ToHours/ToMinutes/ToSeconds Convert a time duration into a number of hours/minutes/seconds. 

Days/Hours/Minutes/Seconds Returns Duration for days/hours/minutes/seconds 

Now, let's take the first row as an example and create these Formulas stepbystep πͺ:
We will check, how many days did we plan to spend on the Task, and how much have we really spent. That formula affects one Database only, so we only need Task Database.
Schema (from our Project Management Template):
Data:
Formula text ( Formula field must be created on the Task level):
ToDays(Planned.End  Planned.Start)
 how many days did we plan to spend
ToDays(Actual.End  Actual.Start)
 how many days have we really spent
Formula explanation:
Notes:
If you have an existing formula (like the one used above), and then change a field name, Fibery will automatically update your formula to reflect the new field name.
Pro users tips πͺ:
Too many formulas make Views cluttered. So, if we want to check the difference between Actual and Planned Durations, we can input that into one formula field. The syntax will look like this.
(ToDays(Planned.End  Planned.Start)  ToDays(Actual.End  Actual.Start))
And it will be also helpful to know how many days have we spent on the Project Level  let's summarize all the Tasks duration.
The syntax will look like this, and the Formula will be created on the Project Level.
Tasks.Sum(ToDays(Planned.End  Planned.Start))
 how many days did we plan to spend
Tasks.Sum(ToDays(Actual.End  Actual.Start))
 how many days have we really spent
And we can even see the difference between Planned and Actual on the Project Level. Here is how the formula will look like:
Tasks.Sum((ToDays(Planned.End  Planned.Start)  ToDays(Actual.End  Actual.Start)))
Logic (If, and, or)
Difficulty level: ββββ
Function  Formula syntax 
If Returns some results based on condition. Switches between two options based on another value. 

Or Use it, when you want to add some conditions, comply with any of which will work for you. The number of conditions is almost unlimited. 

And Use it, when you want to add some conditions, comply with all of which will work for you. The number of conditions is almost unlimited. 

Now, let's create If Formula stepbystep πͺ:
We will check the Status of our Sprint  whether it is a Past, Current, or Future one  based on its period. This Formula already lives in our Software Management template, but it is better to understand it, not only use π§
Schema (from our Software Development Template):
Data:
Formula text ( Formula field must be created on the Sprint level):
If(Dates.End < Today(),"Past",If((Dates.Start <= Today()) and (Dates.End >= Today()),"Current","Future"))
Its looks very long, so let's cut it into two partsIf(Dates.End < Today(),"Past"
 this is smth that happens if the End Date is less than TodayIf((Dates.Start <= Today()) and (Dates.End >= Today()),"Current","Future")
 and this is what happens if it is not
Formula explanation:
If
formula consists of three parts  Condition + (coma) + what happens if Condition is met + (coma) + what happens if Condition is not met  If(condition, true result, false result)
But here comes the tricky part  you can set an If
formula inside the If
formula. Lets have a look at our Formula again.
And go a bit deeper
And how do we read this formula?
If the End Date of our Sprint is before Today, then we say, that this Sprint is Past. If the End day of this Sprint is not before Today, then we have to check  whether the Start Date of our Sprint is Today or before and the End day is Today or after, then this Sprint is Current. If Sprint is neither Past, nor Current, then it is a Future one.
Soso joke as a bonus:
If(You understood the explanation, "π", you are still "π" but explanation is "π©")
Ok, let's check one more example to be sure, we understood how it works πͺ
At first, formulate the expected result in your head as usual  in text. Like "Ok, I think, that this Task is Urgent if it has high Priority and the deadline is coming. Deadline is coming means that is it less than 2 days before the end". And then just convert your thoughts into Formula step by step.
If it has high Priority 
If(Priority.Name = "High")
and the deadline is coming. Deadline is coming means that is it less than 2 days before the end 
If(Priority.Name = "High" and Planned.End < (Today()  Days(2))
Then I think, that this Task is Urgent 
If(Priority.Name = "High" and Planned.End < (Today()  Days(2), "Urgent")
If this Priority is not high or a Deadline is not coming, then this Task is not Urgent 
If(Priority.Name = "High" and Planned.End < (Today()  Days(2), "Urgent", "Not Urgent")
Notes:
If you have an existing formula (like the one used above), and then change a field name, Fibery will automatically update your formula to reflect the new field name.
Please, check that your Database has a field, you are going to work with π§
In this formula, we are writing a lot of words in quotes ("Urgent". "Past", "Current") by quotation marks we denote Names.
Your True/False result doesn't have to be Text. It can be actions  formulas  Sum, Avg, Min, Max, etc.
Common Fibery Errors  what does it mean
Reference to undefined field
This Error means, that field, you are going to operate with doesn't exist. Maybe you've forgotten to create it, or maybe just made a syntax mistake.
Here I'm asking Fibery to summarize all the Points, Bugs have. But I haven't created such a field, this is why it will not work.
2. The Count function does not accept any arguments
This Error means, that smth wrong happens with the Count function. We don't mention what are we going to Count. We are Counting the number of Entities only, this is why there should be nothing in brackets.
3. Missing closing parenthesis or comma while parsing argument list for undefined
Well, that means, that you've just forgotten to put a punctuation mark somewhere, and for Formulas that is crucial. The only thing that can help here  your attention. For now, Fibery formulas are not smart enough to show you where is smth missed π₯