Linking texts and combining formulas

This article explains how to concatenate texts and how to combine formulas within other formulas to create complex calculations and representations.

Concatenating Texts

Concatenating texts in Smenso is done using the + operator. Both static texts and dynamic values from fields or formulas can be used.

"Text1" + " " + "Text2"

Simple Text Concatenation:

"Project: " + flavor("ProjectTitle")

Result: If the project title is "Marketing Campaign", this results in: "Project: Marketing Campaign"

Text with Dynamic Values:

flavor("User") + " has spent " + sumAll("Costs", true) + " €."

Result: If the user is "Anna Müller" and the sum of costs is 1500, this results in: "Anna Müller has spent 1500 €."

Multiline Texts with Operators:

"Title: " + flavor("ProjectTitle") + "\n" + "Costs: " + sumAll("Costs", true) + " €"

Result: Displays the title and costs on two separate lines.

Smenso supports nesting formulas, allowing other formulas to be used within a formula to create complex calculations.

If in sumAll:

sumAll(if(flavor("Category") == "Marketing", Costs, 0), true)

Result: Sums only the costs from the "Marketing" category, including partial steps.

Concatenation with Dynamic Conditions:

"Status: " + if(flavor("Completed"), "Finished", "Open")

Result: Returns "Status: Finished" if the project is completed, otherwise "Status: Open".

Color Highlighting in Combination with Format:

format(if(sumAll("Costs", true)  10000, "Over Budget", "Within Budget"), "", "", if(sumAll("Costs", true)  10000, "red", "green"))

Result: If the total costs exceed 10,000 €, displays "Over Budget" in red, otherwise "Within Budget" in green.

Nesting Formulas: Formulas can be nested within each other to create dynamic and complex calculations.
Clarity: Use clear and structured formulas to improve readability.
Testing: Verify functionality by building and testing the formula step by step.

A detailed overview of operators can be found in the article Flavors of Type "Formula" .