How to conditionally concatenate texts in LibreOffice?
Conditional concatenate can be useful for example if you want to construct one command line from selected rows.
For sums, there is
SUMIF, but not for strings.
However, there is a solution with an intermediate step: Use a separate column for the evaluated condition. Afterwards, the range of the "conditioned text" can be concatenated.
Concatenate text separated by space where the condition is 1.
|Conditional concatenated text||A C||=CONCAT(C2:C4)|