How can I display the total quantity of mirrored items as a number?
In this case, I would like the formula box to say the total number of ‘used in’. For example ‘6’.
Hi Joseph,
Try:
LEN(SPLIT({Used In},","))
Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.
3 Likes
In the formula use {Connect boards#Count} When creating the formula, select “columns” find your connect boards column, then choose your connect boards column, and in the dropdown choose “Count”. Or just type in the column and then #Count inside the curly braces.
That does the job, thanks for your help!
Hey Giles! Do you know if there’s a way to structure this formula that can go one layer deeper and do a filtered count? i.e. count items on connected board with label x? that way you could have multiple formula columns quickly showing you what you otherwise can only see by hovering over the mirrored status column of the connected board. Thanks!