Subitems and mirrors
Functions that summarize columns holding many values: subitems summaries, mirrored columns and multi-value columns.
Why you need them
A mirrored column, or the summary of a subitems column, returns all the values joined by +, like 120+80+45. Excel functions like SUM can't read that text, so General Caster adds functions that take the column and return one value.
MONDAY.NUMBER.SUM({item's Subitems Cost}) * 1.22 Pro plan
MONDAY.* functions require the Pro plan or higher, except MONDAY.PEOPLE.EMAIL.
Functions
| Function | For columns | Returns |
|---|---|---|
MONDAY.GENERAL.COUNT |
Any | Number of values |
MONDAY.NUMBER.MIN |
Numbers | Lowest number |
MONDAY.NUMBER.MAX |
Numbers | Highest number |
MONDAY.NUMBER.SUM |
Numbers | Sum of the numbers |
MONDAY.NUMBER.AVG |
Numbers | Average of the numbers |
MONDAY.DATE.MIN |
Date, Timeline | Earliest date, as YYYY-MM-DD |
MONDAY.DATE.MAX |
Date, Timeline | Latest date, as YYYY-MM-DD |
MONDAY.DATE.TIMELINE |
Date, Timeline | Timeline from the earliest to the latest date, as YYYY-MM-DD+YYYY-MM-DD |
MONDAY.DURATION.MIN |
Time tracking | Shortest duration, as HH:MM:SS |
MONDAY.DURATION.MAX |
Time tracking | Longest duration, as HH:MM:SS |
MONDAY.DURATION.SUM |
Time tracking | Total duration, as HH:MM:SS |
MONDAY.DURATION.AVG |
Time tracking | Average duration, as HH:MM:SS |
MONDAY.TIMELINE.SUM |
Timeline | Total number of days in all the timelines |
MONDAY.PEOPLE.EMAIL |
People | Emails of the people, separated by + (all plans) |
Using subitems
- In the parent board, show the summary of the subitems column you need (or add a mirror column that points to it). You can hide it later.
- Reference that column in the formula, wrapped in the function you need.
- Use When any column changes as trigger, so the result updates when the summary changes.
Other tricks
- Last value:
TRIM(RIGHT(SUBSTITUTE({item's Mirror}, "+", REPT(" ", 999)), 999)) - First value:
LEFT({item's Mirror}, FIND("+", {item's Mirror} & "+") - 1) - How many times a word appears: see Count a word in subitems.
Older names
The older HELPER.*, SUBITEMS.* and MIRROR.* functions (COUNT, MIN, MAX, SUM, AVG, EARLIEST, LATEST, EARLIESTLATEST) still work but are deprecated: replace them with the MONDAY.* functions above.
Something unclear or missing? Tell us and we'll improve this page.